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: 
adamgaox
Creator
Creator

Select Calculate Dimension will impact field selections

Dear All,

I was doing some kinds of requirements like according to different types of data to limit which monthes to show.

I'm taking calculated dimension as my solution.

When I select KPI as TYPE1 it will show 201803 to 201805

When I select KPI as TYPE2 it will show

When I select KPI as TYPE3 it will show

My Show different month dimension write like this:

=IF(KPI = 'TYPE1',IF(MONTH > v1,MONTH),

    IF(KPI = 'TYPE2',IF(MONTH>v2,MONTH),

         IF(KPI = 'TYPE3',IF(MONTH>v3,MONTH)) 

    ))

v1,v2,v3 are variables set as 201802,03,04

The issues is for example when I want to filter the month and clik on the calculated dimension 201804 in TYPE2 it will automaticly select

KPI both TYPE1 and TYPE2 like below and the sum value will not be what I want

Could anybody explain me the reason of this?Thanks in advance.

Details refer to the attached qvw file

1 Solution

Accepted Solutions
tresesco
MVP
MVP

When you are selecting a value from a calculated dimension, qlik engine would try to select values possible from fields mentioned in the calculation. And this is because, in qlik only field (coming from script) can get selected and not a calculated one in the UI.  So when you select 201804 from the dimension, qlik engine finds that for this value, KPI values 'TYPE1' and 'TYPE2' are possible, so they get selected.

View solution in original post

3 Replies
tresesco
MVP
MVP

When you are selecting a value from a calculated dimension, qlik engine would try to select values possible from fields mentioned in the calculation. And this is because, in qlik only field (coming from script) can get selected and not a calculated one in the UI.  So when you select 201804 from the dimension, qlik engine finds that for this value, KPI values 'TYPE1' and 'TYPE2' are possible, so they get selected.

qlikviewwizard
Master II
Master II

Hi,

Please check this.

Data:

LOAD DATE(DATE#(MonthYear,'YYYYMM'),'YYYYMM') as MonthYear,Sales INLINE [

MonthYear,Sales

201701,5

201702,10

201703,15

201704,5

201705,10

201706,15

201707,5

201708,10

201709,15

201710,5

201711,10

201712,15

201801,5

201802,10

201803,15

201804,5

201805,10

201806,15

201807,5

201808,10

201809,15

];

Expression:

sum({<MonthYear={"<=$(=DATE(max(MonthYear),'YYYYMM'))"}>}Sales)

Capture1.PNG

adamgaox
Creator
Creator
Author

Hi Tresesco,

Thanks for your replying.Agree with you.

This is really an important notification when using calculated dimension in qlik products.

Best Regards.

Jiawen.