topic Re: Help on set variable in QlikView

Help on set variable

Anonymous — Thu, 08 Jun 2017 14:56:52 GMT

Hi,

I am trying to make a pivot table which comprise of budget headcount data (month on month) . By design, the headcount numbers are progressive (e.g Feb'17 heacount numbers, will show Jan+Feb (YTD)). i need help on how to ensure that for any given month, the table shows me data relevant only to that period.

my set variable

sum({<Scenario={Budget}, HeadCountType={"HC Request","PH","Open","PHWS","Attrition Replacement"},DateType={THD},year={$},month={$}>}[FTE_Alloc])

Thanks in advance

Re: Help on set variable

sunny_talwar — Thu, 08 Jun 2017 17:10:27 GMT

Are you using Year and Month as your dimensions?

Re: Help on set variable

Anonymous — Fri, 09 Jun 2017 08:08:53 GMT

Yes i am

Re: Help on set variable

antoniotiman — Fri, 09 Jun 2017 08:14:11 GMT

You remove

Month={$),Year{$} don't need

Correct is

Year=$::Year,Month=$::Month

however You don't need because you don't have any Alternate State in Your Expression.

Default is Current state/selection {$}

Re: Help on set variable

sunny_talwar — Fri, 09 Jun 2017 08:58:45 GMT

In that case you have two options

1) Use The As-Of Table

2) Use Missing Manual - Above() and Below() functions