How to hide measure column based on no of dimensions visible?

[nikhilgarg]

Hello,

I have an application where i have 2 measures as :

SalesDI1  and SalesDI2.

If all my dimensions are expanded, i want SalesDI1 to be visible and SalesDI2 to be invisible.

If only my R1 and D1 dimensions are there and all other dimensions collapsed then i want SalesDI2 to be visible and SalesDI1 to be invisible.

I tried acheiving that with dimensionality() but couldn't do that. Can anyone help em on this?

Thanks

[vardhancse]

Hi I don't think so based on dimensions expansion visibility will work out.

Based on selections may be visibility might work.

[tresesco]

Dimensionality won't work here since it will always return zero outside the chart rows, and expression calculation conditional expression evaluates outside the chart rows. This might be possible with macro (not sure though), but that is not recommended. Read: Macros are Bad

[qlikviewwizard]

Did you check if conditional dimensions will work?

[nikhilgarg]

Hey,

How wld conditional dimensions work ?

[jonathandienst]

I think you will need to use a variable to control the dimension and expression visibility. You will probably also need a button to toggle the variable between the 2 states.

All dimensions (except R1 and D1) are conditional on the variable = 1

Expression 1 is conditional on the variable =1 and expression 2 on the variable = 0

The button action expression:  =If(vToggle = 0, 1, 0)

[vardhancse]

Conditional Dimension will work something like;

SubStringCount('|'&Concat([% Fieldname],'|')&'|','|data|')

but conditional can work based on selection, but not on dimensions expansion

[jagan]

Hi,

Here Dimensionality won't work, also it is not suggestible to use the Macros, macros won't work in all the place.  Instead you can try adhoc reporting.  Check below link

Adhoc reporting in Qlikview

Regards,

Jagan.

[nikhilgarg]

Hey,

Thanks but i don't understand your below statement:

"Dimensionality won't work here since it will always return zero outside the chart rows, and expression calculation conditional expression evaluates outside the chart rows." Can you plz explain?

[nikhilgarg]

Hey,

Thanks but we dont want an added button. Any other alternative?

thanks