topic Re: Date Field In Set Analysis in QlikView

Date Field In Set Analysis

Anonymous — Tue, 23 Jul 2013 15:55:01 GMT

I'm trying to use set analysis for showing values of 7 days minus the selected date but it shows the results same as for the current date:

=sum({<Cal.Date={'=$(vWkStrt)'}>}MKT_INDX)

where,

vWkStrt = Cal.Date-7

Also, I tried putting Cal.Date-7 in set analysis, did not work.

In the text object when I display vWkStrt, it shows me a number value, if I do Date(vWkStrt) then I see Cal.Date in MM/DD/YYY format.

Is there something wrong with the syntax or the date formating ?

Gysbert_Wassenaar — Tue, 23 Jul 2013 15:58:19 GMT

Probably the formatting. Try =sum({<Cal.Date={'$(=date($(vWkStrt)))'}>}MKT_INDX)

shree909 — Tue, 23 Jul 2013 15:59:07 GMT

Hi change the variable syntax to the ca. date format

try this

vWkStrt =Date( Cal.Date-7,'MM/DD/YYYY')

the variable value must always match the fieldvalue date(cal.Date) then only set analysis work

Anonymous — Tue, 23 Jul 2013 22:29:14 GMT

Thank you both, those were very helpful replies.