tricky date condition in set analysis

[aniruddhyadutta]

Hi All,

I am using a expression in set analysis where I want to show the cumulative sum of alert_count for  the present hour,present-1,present- 2 hour .here the variables $v2, $v3 and $v4 are calculating as hours.This is coming as fine

RangeSum(Above(Sum({$< Hour_link={'$(v2)','$(v3)','$(v4)'}>} ALERT_Count),0,RowNo()))

But the problem is that I want to have my chart selected for the max date  for which I used

RangeSum(Above(Sum({$< Hour_link={'$(v2)','$(v3)','$(v4)'},Dates={'$(v5)'}>} ALERT_Count),0,RowNo()))

my variable i.e $v5 is fetching as expected date which is the maximum of my data set.I just wanted to use that condition Dates=$v5

in my database datatype of Dates filed is date only.

can someone please help me out!

Thanks,

Aniruddhya

[Anonymous]

I used QlikView 12 SR 5 for my example.

If the hardcoded variant doesn't work, it looks like a bug for me.

You could try QlikView 12 Personal Edition for testing. It is basically the same.

If you get another result, then it should be a bug....

[Vegar]

Aniruddhya Dutta wrote:

...

RangeSum(Above(Sum({$< Hour_link={'$(v2)','$(v3)','$(v4)'}>} ALERT_Count,Dates={'2016-Oct-26'}),0,RowNo()))

I believe you got the syntax wrong in this test. Try:

RangeSum(Above(Sum({$< Hour_link={'$(v2)','$(v3)','$(v4)'},Dates={'2016-Oct-26'}>} ALERT_Count),0,RowNo()))