topic Re: Set analysis in QlikView

Set analysis

stephenedberkg — Mon, 04 Jan 2016 07:18:13 GMT

i have two calendar one for uploading month and year and another one is forecast month and year

in my dashboard i made uploading month and year as calendar

but the above screen shot values is wrong

each code have some lock period like 1,2,3.

since code CP6426 has lock period as 2 i want the march sales values

i want achieve this without clicking march.

my expression is =sum({<Years={$(=Max(Years))},MonthIDS = {$(=Max(MonthIDS))}>}Sales)

how to write this logic in set analysis

Re: Set analysis

tresB — Mon, 04 Jan 2016 07:29:31 GMT

Not very clear what you are trying to get. Is March your max month? What is it's MonthID number? Could you explain a bit more?

Re: Set analysis

HirisH_V7 — Mon, 04 Jan 2016 07:30:31 GMT

Hi,

Can you post your sample app and Required output??

-Hirish

Re: Set analysis

stephenedberkg — Mon, 04 Jan 2016 07:33:47 GMT

not like that when we click jan its should display jan + lock period that is 1+ 2 =3 that is march

Re: Set analysis

tresB — Mon, 04 Jan 2016 07:40:08 GMT

Try like:

Create a variable like:

vLockPeriod =LockField

=sum({<Years={$(=Max(Years))},Month= {$(=Month(Addmonths(Max(DateField),$(vLockPeriod))))}>}Sales)

Re: Set analysis

Mon, 04 Jan 2016 07:42:15 GMT

sample app

Re: Set analysis

stephenedberkg — Mon, 04 Jan 2016 07:43:37 GMT

i have the master calendar for both upload and forcast

Re: Set analysis

tresB — Mon, 04 Jan 2016 07:59:05 GMT

All questions to be followed would be answered if you could upload your sample qvw.

Re: Set analysis

stephenedberkg — Mon, 04 Jan 2016 08:51:55 GMT

i have attach the sample QVW file and excel data.

help me.

Re: Set analysis

stephenedberkg — Mon, 04 Jan 2016 08:52:44 GMT

i attach the sample qvw file

Re: Set analysis

tresB — Mon, 04 Jan 2016 09:06:59 GMT

Is 144 your expected output when selecting Month-Jan, ID-2? If so, try like:

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

Re: Set analysis

stephenedberkg — Mon, 04 Jan 2016 09:12:59 GMT

no i want display 53.

we should not add two month sales values,we want to add only the month with lock period

Re: Set analysis

tresB — Mon, 04 Jan 2016 09:18:43 GMT

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

Re: Set analysis

stephenedberkg — Mon, 04 Jan 2016 09:19:03 GMT

=num(Sum({$< UYear = {$(=Max(UYear))} ,UMonthID = {$(=Max(UMonthID))},FMonthIDS={$(=max({$< UMonthID = {$(=Max(UMonthID))}

,UYear = {$(=Max(UYear))} >}FMonthIDS) )} > } sales),0.00)

i wrote like this

Re: Set analysis

stephenedberkg — Mon, 04 Jan 2016 09:24:10 GMT

tresesco‌

it is correct but when id is selected only its displaying the values.

when it is not selected the values is zero but i cant show like this in dashboard.

Re: Set analysis

tresB — Mon, 04 Jan 2016 09:27:00 GMT

Let us know what is your expected output when ID is not selected.

Re: Set analysis

stephenedberkg — Mon, 04 Jan 2016 09:29:28 GMT

for jan my output is should be 225 without selecting the id