topic Change Chart Expression Depending on What Cyclic Dimension is selected in QlikView

Change Chart Expression Depending on What Cyclic Dimension is selected

prees959 — Wed, 26 Jun 2019 13:05:32 GMT

Hi, I have a Cyclic Dimension in my chart,

At the moment the expression is Sum([Total Sales])

There is one Dimension that when selected I need to change the the Expression to Count(Manufacturer)... is this possible?

Many Thanks,

Phil

sunny_talwar — Wed, 26 Jun 2019 13:21:42 GMT

What is the dimension name and what is the group name?

Alaaaq — Wed, 26 Jun 2019 13:29:13 GMT

try using if GetCurrentSelections function

example

=if(GetCurrentSelections([dimesnion],'value),

//IF TRUE

sum(field),

//IF FALSE

count(field)

)

dplr-rn — Wed, 26 Jun 2019 13:32:31 GMT

did you try GetCurrentField

e.g.

if(GetCurrentField(TestCylc)='Dim1', expression1, expresion2)