topic Use an expression in a calculated dimension in QlikView

Use an expression in a calculated dimension

Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone ,

I hope you can help me with this issue.

I have this data :

I tried to have a table to show only lines where the sum of quantity1 < the sum of quantity2 when flag="Validated".

I have variables like this :

v_quantity1 = sum({<Flag={'Validated'}>} quantity1)

v_quantity2 = sum({<Flag={'Validated'}>} quantity2)

I tried to use a calculated dimension like this :

- Test 1 : if($(v_quantity1) < $(v_quantity2),1,null()) + check the box "suppress when the values is null"

- Test 2 : if( if(Flag="Validated",sum(quantity1) < if(Flag="Validated",sum(quantity2),1,null()) + check the box "suppress when the values is null"

It doesn't work. I have this error : "Garbage after expression"

I simplify my issue but I have to do a sum. I have others filters like X = "1" for example and it works in a calculated dimension.

Do you have any idea please ?

Kind regards ,

Gwendaline

antoniotiman — Thu, 15 Jun 2017 16:46:29 GMT

Hi,

maybe this

Dimensions :

Aggr(If(Sum(Quantity1) < Sum(Quantity2) and Flag = 'Validated',ID2),ID2)

Flag

Regards,

Antonio

Mon, 19 Jun 2017 09:42:53 GMT

Yes, it works !

Thank you Antonio !

ViktoriyaParshin — Tue, 25 Aug 2020 12:52:19 GMT

Hello,

Maybe, somebody faced this problem and could help me :-).

I created the calculated column. After the receiving the results, I need remove "Null"s

"Expressions" returns me the correct results, but impossible remove Null values in model

Calculated dimension, where Null remove is possible, - presents not correct results .

my calculation is:

=if (T_Number = Max_T_Number or (IsNull (T_Number) and Qty_On_Hand > 0.1 ), 'New', Null())

thank you!