Qlikview set analysis , Between two values

=

//SUM({<FactAll.RSTrakingDaySEQ={$(vRS_TrackingDaySEQ)}  >} $(vMeasures01Value))
//SUM({<FactAll.RSTrakingDaySEQ={">=$(vRS_TrackingDaySEQ)<=$(vRS_TrackingDaySEQ)"}  >} $(vMeasures01Value))
SUM({<FactAll.RSTrakingDaySEQ={">=1<=$(vRS_TrackingDaySEQ)"}  >} $(vMeasures01Value))


ข้อห้ามมมม ห้ามมี Space ระหว่าง >= <= เด็ดขาด จะทำให้ผลลัพธ์ผิด
" " Space is cause to error result! Pls eliminate it from {}

Qlikview Chart property is gone! or missing (Solved)

Some time Qlikview wasn't response.
Example I create a chart and adding/adjust some expression and then I click "OK"
The dialog disappear! But It seem the dialog still there! What happen then.
I can do nothing with that screen.
I try to close the others running program ,switch application but have no luck.
Searching in Google still not found any one who have this problem.

AND THEN I realize that I've not try to use the key board key.
So this problem was solved by Press Ctrl+S to save the file and then End task Qlikview.

For better save your ass is to Press Ctrl + F12 (Save as a new file)
Because I've facing some kind of problem that more seriously ,File damaged after saving.
Size of file decrease to 0 KB .
Good luck buddy!

X axis problem when using Linest_M function

AGGR & LINEST_M function


Thank you to https://community.qlikview.com/thread/115111

SOLVED by using : aggr( rowno(), yearmonth))

The trendline formula uses the index number of the x-axis dimension values, i.e the left most value is 1, the next 2 etc. The linest_m function uses the actual x-axis dimension values. You could try:

linest_m(aggr( sum(....vSold...)/sum(....Quantita...) , yearmonth), aggr( rowno(), yearmonth))

See attached example.