topic Re: How to create a condition for dimension value? in QlikView

How to create a condition for dimension value?

Wed, 02 Sep 2015 14:40:32 GMT

Hi,

I use 2 arrays with dates in my QV report -> Datum and Datum2.

There is a listbox for filtering by the dates which contains values from Datum.

Datum2 contains the same values, but not as many values as in Datum.

In my table, I use dimension Date -> if the date is selected in listbox, I want to use the value from Datum, but if NO date is selected in listbox, I want to use all values from Datum2.

I created calculated dimension, but it does not work as expected...

Condition like:

=if(Datum<>'',Datum,Datum2)

The result is that all values from Datum are used, when no selection of date was done - not correct.

I also tried this:

=if(Datum='',if(

Datum<>Datum2,Datum,Datum2),Datum2)

The result is that all values from Datum2 are used, when no selection of date was done - correct, but then when I select a date in Datum listbox which is not icluded in Datum2, it shows just empty table..

Please, help me.

Many thanks in advance

Nela

Re: How to create a condition for dimension value?

sunny_talwar — Wed, 02 Sep 2015 14:43:53 GMT

Try this may be:

If(GetSelectedCount(Datum) = 0, Datum, Datum2)

If(GetSelectedCount(Datum) = 0, Datum2, Datum)

Re: How to create a condition for dimension value?

Wed, 02 Sep 2015 14:47:00 GMT

Wow, that was easy..thank you sooo much!!!

Re: How to create a condition for dimension value?

sunny_talwar — Wed, 02 Sep 2015 14:47:21 GMT

Did that really work?? I was still trying to make sense of the expression I suggested:)

Re: How to create a condition for dimension value?

Wed, 02 Sep 2015 14:48:31 GMT

Yeah, it works just as needed

Re: How to create a condition for dimension value?

sunny_talwar — Wed, 02 Sep 2015 14:49:14 GMT

Awesome