topic Re: Adhoc report selection in QlikView

Adhoc report selection

priyarane — Mon, 07 Sep 2015 14:22:54 GMT

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

Re: Adhoc report selection

Gysbert_Wassenaar — Mon, 07 Sep 2015 14:45:51 GMT

Try enable condition expressions like:

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

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

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

Re: Adhoc report selection

priyarane — Mon, 07 Sep 2015 14:57:03 GMT

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

Re: Adhoc report selection

Gysbert_Wassenaar — Mon, 07 Sep 2015 15:08:52 GMT

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.

Re: Adhoc report selection

priyarane — Mon, 07 Sep 2015 15:18:03 GMT

Hi Gysbert,

Got it,

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

Thank you