topic Re: set Analysis with Set command in QlikView

set Analysis with Set command

arusanah — Thu, 23 Apr 2015 16:36:51 GMT

Can we use set analysis in Set command :

set vDateFromUI	= addmonths(monthstart(max({$<TimeLine.Year={$(=max(TimeLine.Year))}>}[Date])),-12);
set vDateToUI	= addmonths(MonthEnd(max({$<TimeLine.Year={$(=max(TimeLine.Year))}>}[Date])),-1);

when I use these expressions in text object it works fine . but when i am trying to use them for Set or Let .. it fails .

pls help

Re: set Analysis with Set command

buzzy996 — Thu, 23 Apr 2015 16:43:44 GMT

As per my knowledge,NO.

Re: set Analysis with Set command

sunny_talwar — Thu, 23 Apr 2015 17:21:48 GMT

You won't be able to use the set analysis in the back end, but I am sure you can assign a expression which include set analysis in the back end. try it this way and see if this works:

LET/SET vDateFromUI	= '=addmonths(monthstart(max({$<TimeLine.Year={$(=max(TimeLine.Year))}>}[Date])),-12)';
LET/SET vDateToUI	= '=addmonths(MonthEnd(max({$<TimeLine.Year={$(=max(TimeLine.Year))}>}[Date])),-1)';

Not entirely sure if LET or SET will work, but I feel one of them should work.

HTH

Best,

Sunny

Re: set Analysis with Set command

arusanah — Thu, 23 Apr 2015 17:36:43 GMT

I Tried the same expression in text obj it works . and text objects uses " LET" . so i think using above expression with Let should work.

Re: set Analysis with Set command

sunny_talwar — Thu, 23 Apr 2015 17:38:21 GMT

Ya give it a shot and let me know what worked.

Best,

Sunny

Re: set Analysis with Set command

arusanah — Thu, 23 Apr 2015 19:17:56 GMT

Hi there ,

LET Works

Re: set Analysis with Set command

sunny_talwar — Thu, 23 Apr 2015 19:19:53 GMT

Awesome!