Adhoc report selection

[priyarane]

Hi Community,

I have a issue with adhoc report like below/

Dimensions

Dim1

Dim2

Dim3

In straight table for I am using X_Dim for the above

so If I select any one of above dimension then X_Dim should be enable.

Right now I am using enable condition like: SubStringCount(Concat(%Dimension,'|'),'Dim1') .

But I need to make X_Dim for all three so, can some one please help me

- Priya

[Gysbert_Wassenaar · Accepted solution]

Try enable condition expressions like:

max(match(%Dimension,'Dim1'))

max(match(%Dimension,'Dim2'))

max(match(%Dimension,'Dim3'))

[priyarane]

Hi Gysbert,

How we will copy this Condition for Enable conditional. its throwing errors should I use If condition some where, Could you please brief about it.

- Thank you

[Gysbert_Wassenaar]

I'm afraid I don't understand what you're trying to explain. Perhaps you can upload a small qlikview document that demonstrates the problem and explains what you want.

[priyarane]

Hi Gysbert,

Got it,

I tried like this max(match(%Dimension,'Dim1','Dim2'....))

Thank you