topic Re: Set Analysis, Dates and Variables in QlikView

Set Analysis, Dates and Variables

Anonymous — Fri, 20 Apr 2018 15:42:34 GMT

I want to use Set Analysis on a date but I seem to miss the correct formatting.

I load something like this :

LOAD

date(@1) as DateExport,

Ratio

FROM

(bla,bla...)

In my load script, I calculate the max value

SET vMaxDate = max({1} DateExport );

Later on in my charts I want to use this

=max({$ < DateExport={'$(vMaxDateVisites)'} >} Ratio)

which fails miserably but the following line works like a charm

=max({$ < DateExport={'19/04/2018'} >} Ratio)

What am doing wrong with my vMaxDate variable or Set Analysis syntax?

Anonymous — Fri, 20 Apr 2018 15:48:05 GMT

Hi Olivier,

i think that you are not using the same variable that u did declare no?

Digvijay_Singh — Fri, 20 Apr 2018 15:49:44 GMT

Hi,

Set Analysis doesn't work in script. You can use Max function directly in the measure expression something like this -

=max({$ < DateExport={"=$(=Max(DateExport))"} >} Ratio)

Anonymous — Fri, 20 Apr 2018 16:05:00 GMT

Thanks this works.

sunny_talwar — Fri, 20 Apr 2018 16:19:25 GMT

I wonder if the set analysis is even working digvijay‌, you seem to have an extra parenthesis before $(

=max({$<DateExport={"=$(=Max(DateExport))"} >} Ratio)