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.

How to add qlikview user cal (License)

- Open QV Management console
- Click tab "System"
- Select "Qlikview Server"
- Select sub tab "License"
- Select Client Access License (CALs)
- Select Assigned CALs

Allocated Memory Exceeded - QV11 | Qlik Community

https://community.qlik.com/thread/41825

Bug in QV 11

-Try to create a new chart instead of copy from the old one.

Qlikview , Set analysis greater than ,">="

Syntax

SUM(
{ < Calendar.Date = {">=$(=FLOOR(NUM(NOW()-30)))"} >}

FactAll.Fee)

// Sum of last 30 days ">="

Qlikview , Sum sale of top N customer of each month

Using RANK function to check ranking of summary

Case1: Display rank with customer name for each month
Dimension1 = FactAll.MTH_YEAR
Dimension2 = Rank (Calculated Dim)
Dimension3 = CustomerName (Calculated Dim)

Dim2 :Rank
=Aggr(rank(sum(FactAll.Fee)),FactAll.MTH_YEAR ,Account.CustomerName)

Dim3 :CustomerName
=IF(AGGR(RANK(SUM(FactAll.Fee)),FactAll.MTH_YEAR, Account.CustomerName)<= 100 , Account.CustomerName )

Case2: Display only summary of top 100 customer fee
Dimension1 = FactAll.MTH_YEAR
Expression = SumFee

Measure Expression :
=SUM(
IF(Aggr(rank(sum(FactAll.Fee)),FactAll.MTH_YEAR ,Account.CustomerName)<=100,
Aggr( sum(FactAll.Fee) ,FactAll.MTH_YEAR ,Account.CustomerName))
)