topic Re: How to transform expression in Dimension in QlikView

How to transform expression in Dimension

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello

i already have a bar chart with this expression sum(aggr(if(Count([Libellé])=1,1,0),[Référence mouvement 2]))

How can i create a dynamic dimension with this expression : sum(aggr(if(Count([Libellé])=1,1,0),[Référence mouvement 2]))

This expression is to categorize the number of product [libellé] by order [Référence mouvement 2] . in this case, it count how many order have just one product

i want to have a dynamic dimension like

= 1 [libellé]

= 2 [libellé]

= x[libellé]

= > x [libellé]

and an expression : count ([Référence mouvement 2]) or sum(value)

How can i do that ?

thank you for all.

Re: How to transform expression in Dimension

kaushiknsolanki — Mon, 13 Feb 2017 09:11:45 GMT

Try this,

aggr(Count(Distinct [Libellé]),[Référence mouvement 2])

Regards,

Kaushik Solanki

Re: How to transform expression in Dimension

Anonymous — Mon, 13 Feb 2017 10:00:35 GMT

Thanks you

it seem's working

do you know how can i order this ? i'll try few thiongs but nothings works?

Re: How to transform expression in Dimension

kaushiknsolanki — Mon, 13 Feb 2017 10:06:01 GMT

Hi,

You can promote the Dimension to top and then select the Numeric Value as sort order.

Regards,

Kaushik Solanki

Re: How to transform expression in Dimension

Anonymous — Mon, 13 Feb 2017 10:10:26 GMT

Hello again

- i made a dimension like : aggr(Count(Distinct [Libellé]),[Référence mouvement 2]) = 2 (or another number)

- My expression : Count (distinct([Référence mouvement 2]))

i have some négative results? i don't know how interpret it ? is it "normal"

did i made a mistake on my dimension?

Re: How to transform expression in Dimension

Anonymous — Mon, 13 Feb 2017 10:12:52 GMT

Yes!!

it works for the order.