QlikView App Dev

[Qvmaster2019]

What I need is to create a simple pivot table. with RSM, Dealer and Dealer Rep as dimensions and have it fixed for 2011.

So i was able to do it, but whenever i am trying to select a specific RSM, it won't hide those that should be excluded.

I have attached the file. Any ideas?

[adhudson]

Hi,

     I have attached the updated file.

     I think the only change you need to do is just remove '1' from all the set expressions since it will consider all the values of the fields given.

     That's why your selections are not made when you do.

Regards

Andrew Hudson

[erichshiino]

Hi,

You can remove the 1 in set analysis

Thus,

sum({1<Year={2011}, Month={'Aug'}>} Value) will become:

sum({<Year={2011}, Month={'Aug'}>} Value)

The 1 makes the expression to ignore any selections.

Also, in your pivot, you can go to settings -> Presentation and check the 'suppress zero values' to remove the lines where all the values are zeroes

Hope this helps,

Erich

[Qvmaster2019]

Removing 1 will give me an inaccurate data. Please check the difference in the numbers when 1 is removed compared to the original. You will see that some of the values turn to zero.

[Qvmaster2019]

ie. Lots of Zero's will appear when there is a selection in the month.

[erichshiino · Accepted solution]

Hi,

You may add MonthName = in set analysis to ignore the selections on that specific dimension

It will become:

sum({<Year={2011}, Month={'Aug'}, MonthName = >} Value)

or any other field you may need to add:

sum({<Year={2011}, Month={'Aug'}, MonthName  = , OtherField = >} Value)

Hope this helps,

Erich

[Qvmaster2019]

Thanks Erich!

This one works:

sum({<Year={2011}, Month={'Aug'}, MonthName = >} Value)

Regards,

dnatividad