Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Qvmaster2019
Creator
Creator

SIMPLE SET ANALYSIS:Date should be fixed but the dimension should change

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?

1 Solution

Accepted Solutions
erichshiino
Partner - Master
Partner - Master

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

View solution in original post

6 Replies
adhudson
Creator II
Creator II

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
Partner - Master
Partner - Master

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
Creator
Creator
Author

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
Creator
Creator
Author

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

erichshiino
Partner - Master
Partner - Master

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
Creator
Creator
Author

Thanks Erich!

This one works:

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

Regards,

dnatividad