Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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....
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()))