topic Re: Display Conditional dimensions in QlikView

Display Conditional dimensions

Wed, 07 Sep 2016 13:03:21 GMT

I have a table and set of pivot dimensions in some list boxes (See attached) .

I have given the condition:

GetSelectedCount (C_dimension) > 0 OR GetSelectedCount(S_dimension) > 0 OR GetSelectedCount(M_dimension) > 0 OR GetSelectedCount(P_dimension) > 0

for the table in calculation condition field in the 'General' tab of table properties. And with a condition like

=SubStringCount('|' & Concat(distinct C_dimension, '|') & '|', '|Customer|')

for every dimension in the 'enable conditional' option.

All the columns are getting displayed in the table when I did not select any pivot dimension from the list box. (Attached scenario displays all the dimensions from 1st ,2nd 4th list boxes even when they are not selected. For this scenario I want to display 'Material' and corresponding expressions 'Total Sales E' , 'Total Sales Y' only. It should not display un-selected dimensions from other list boxes ).

I read the dimensions from the following script.

CustomerDimensions:

LOAD * INLINE [C_dimension

Customer

Business Area

Country

Profit Center

Region

];

SalesDocDimensions:

LOAD * INLINE [S_dimension

Sales Office

Sales Order

Currency

Sales Order Item

];

MaterialDimensions:

LOAD * INLINE [M_dimension

Material

MaterialDescription

MUG Header

Material Category

MUG

NKE

];

PeriodicalDimensions:

LOAD * INLINE [P_dimension

Week

Year

Month

];

I want the table not to display columns which i don't select. Should show some message if i don't select any dimension at all.

TIA,

James

Re: Display Conditional dimensions

jonathandienst — Wed, 07 Sep 2016 13:09:24 GMT

Use GetFieldSelections rather than Concat:

=Index('|' & GetFieldSelections(C_dimension, '|', 40) & '|', ',|Customer|,')

Concat() returns all the values if nothing is selected, but GetFieldSelections() has the required behaviour.

Re: Display Conditional dimensions

Wed, 07 Sep 2016 13:23:15 GMT

Hi Jonathan,

GetFieldSelections returns none even after selecting one dimension from each list box. It displays expressions alone.

Please help.

-James

Re: Display Conditional dimensions

tracysmart — Wed, 07 Sep 2016 13:31:54 GMT

Hi James

I do exactly the same thing in my app and this expression works fine for me in the Enable Condition of one of the dimensions (changing the 'TAC' part accordingly for each dimension)

=SubStringCount(Concat(_DimensionID, '|'), 'TAC')

so yours would be

=SubStringCount(Concat(C_dimension, '|'), 'Customer')

Does this work for you?

Re: Display Conditional dimensions

Anonymous — Wed, 07 Sep 2016 13:35:20 GMT

as Jonathan answered this will get you all values of the Dimension if nothing is selected

enhance your part by GetSelectedCount (C_dimension) > 0 and it works even if None is selected

=(GetSelectedCount (C_dimension) > 0) and (SubStringCount(Concat(C_dimension, '|'), 'Customer')>0)

Re: Display Conditional dimensions

Wed, 07 Sep 2016 13:36:27 GMT

Unlucky !

I already tried it Tracy !!

I guess there is a gap between my 'calculation condition' and 'Enable conditional' , isn't it ??

-James

Re: Display Conditional dimensions

Wed, 07 Sep 2016 13:43:54 GMT

I am not able to get your answer Rudolf.

You mean to enhance my 'calculation condition' from GetSelectedCount (C_dimension) > 0 to (GetSelectedCount (C_dimension) > 0)

and 'Enable Conditional' from SubStringCount('|' & Concat(distinct C_dimension, '|') & '|', '|Customer|')

to (SubStringCount(Concat(C_dimension, '|'), 'Customer')>0)

Am i right ?

-James

Re: Display Conditional dimensions

Anonymous — Wed, 07 Sep 2016 13:48:59 GMT

no you Need to add the complet Expression for each column in enable condition

=(GetSelectedCount (C_dimension) > 0) and (SubStringCount(Concat(C_dimension, '|'), 'Customer')>0)

calculation condition will allow you to Show or not to show the Chart, while enable condition allows you to control each single column one by one

as I understood you want to control the behaviour in a table. you select a value from your dimensions and this column should be displayed and not others which are not selected

Re: Display Conditional dimensions

sunny_talwar — Wed, 07 Sep 2016 13:51:16 GMT

Your calculation condition for the chart can be this

GetSelectedCount (C_dimension) > 0 OR GetSelectedCount(S_dimension) > 0 OR GetSelectedCount(M_dimension) > 0 OR GetSelectedCount(P_dimension) > 0

and then for individual dimensions, you can try one of the two options as proposed above

2) =SubStringCount('|' & GetFieldSelections(C_dimension, '|') & '|', '|Customer|')

Re: Display Conditional dimensions

Wed, 07 Sep 2016 14:03:39 GMT

Perfect !

Thank you so much Sunny ! The MAN !! (Y)

Following combo worked.

calculation condition:

GetSelectedCount (C_dimension) > 0 OR GetSelectedCount(S_dimension) > 0 OR GetSelectedCount(M_dimension) > 0 OR GetSelectedCount(P_dimension) > 0

Individual dimensions:

-James

Re: Display Conditional dimensions

LCardonne — Mon, 21 Jan 2019 09:15:15 GMT

Hi,

I'm doing the very same thing and it works fine when I'am in the dev mode.

But it does not work any more when I deploy the document on the server! 😞

Would you have any idea why?

I actually have the same issue with another method also using "enable conditional" for dimension: I use a variable v_ShowHide that is switched from 0 to 1 by a button and the enabling condition is "v_ShowHide =1". I have also tried "$(v_ShowHide) =1", "=if(v_ShowHide =1, 1, 0)", "=if($(v_ShowHide)=1, 1, 0)"... All work on my PC in dev app but not on the server!

Cheers,

Lilian