topic Re: Select Calculate Dimension will impact field selections in QlikView

Select Calculate Dimension will impact field selections

adamgaox — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Select Calculate Dimension will impact field selections

tresB — Fri, 14 Sep 2018 07:15:32 GMT

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.

Re: Select Calculate Dimension will impact field selections

qlikviewwizard — Fri, 14 Sep 2018 07:24:02 GMT

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)

Re: Select Calculate Dimension will impact field selections

adamgaox — Sat, 15 Sep 2018 03:56:07 GMT

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.