Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP
MVP

Re: Select Calculate Dimension will impact field selections

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
Highlighted
MVP
MVP

Re: Select Calculate Dimension will impact field selections

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

Highlighted
Master II
Master II

Re: Select Calculate Dimension will impact field selections

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

Highlighted
Creator
Creator

Re: Select Calculate Dimension will impact field selections

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.