topic Re: Set analysis based on lock period in QlikView

Set analysis based on lock period

stephenedberkg — Tue, 05 Jan 2016 07:34:41 GMT

here with i attach the sample app

if i selected the ID only the sales values are displaying but without selecting the ID the sales values is zero.

i cant show zero in dashboard instead of that i want to show the MTD and YTD sales values for all IDs.

MY expression is

=sum({< Years={$(=Max(Years))},Months= {$(=Month(Addmonths(Max(UploadDate),$(vLockPeriod))))},ID>}sales)

Re: Set analysis based on lock period

sasikanth — Tue, 05 Jan 2016 07:52:21 GMT

hi,

Instead you can show always for a max ID ,

Re: Set analysis based on lock period

stephenedberkg — Tue, 05 Jan 2016 10:05:07 GMT

=sum({< Year={$(=Max(Year))},MonthID={$(=Max(MonthID))},MonthIDS={$(=Max(MonthID)+ $(vLockPeriod) )}>}sales)

when i select the ID that time only its working correctly without select the ID the sales is zero.

do you have any ideas for this?

Re: Set analysis based on lock period

sunny_talwar — Tue, 05 Jan 2016 10:16:13 GMT

$(vLockPeriod) evaluates to - (Null()) when no id is selected. and that is why AddMonths doesn't seems to be working. There are three options available within lock period field, which one would you want it to be without selection?

Re: Set analysis based on lock period

stephenedberkg — Tue, 05 Jan 2016 11:25:45 GMT

Dear sunindia

i want the sum of all.i think its not possible in set analysis.

can we do anything in script?