Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

darwin_nativida
Contributor

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?

Tags (2)
1 Solution

Accepted Solutions
erich_shiino
Honored Contributor

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

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

6 Replies
adhudson
Contributor II

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

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

erich_shiino
Honored Contributor

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

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

darwin_nativida
Contributor

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

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.

darwin_nativida
Contributor

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

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

erich_shiino
Honored Contributor

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

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

darwin_nativida
Contributor

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

Thanks Erich!

This one works:

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

Regards,

dnatividad

Community Browser