topic Re: Conditional expression on a chart in QlikView

Conditional expression on a chart

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

Dears,

I have a chart with

Dimensions = Stickers and,
Expression =num(avg([P/L]), '#.##0,00;-#.##0,00')

So, the user can select some Stickers, as dimensions, and I would like that, if just one Sticker is selected, the system should show 2 bars, the one related to the expression, and another one with the following formula: "=num(avg({<Sticker,SubsetorEmpresa=p(SubsetorEmpresa)>}[P/L]),'#.##0,00;-#.##0,00')"

I'm trying to use the conditional function with the following formula:
"= IF(GetSelectedCount(Sticker) > 0, 1, 0)", but it's not working properly..

How can I do it?

Thanks

Bruno Lelli

Re: Conditional expression on a chart

Lisa_P — Sun, 03 May 2020 22:58:22 GMT

On the second expression, use the condition:
= IF(GetSelectedCount(Sticker) > 0)

Re: Conditional expression on a chart

brunolelli87 — Sun, 03 May 2020 23:23:56 GMT

It's not working

What do you mean by the second expression?

Please, check the picture...

Re: Conditional expression on a chart

brunolelli87 — Mon, 04 May 2020 00:02:02 GMT

I found a way to solve it...

On condition field:
GetSelectedCount(Sticker) = 1

On expression field:
=num(avg(TOTAL {<Sticker,SetorEmpresa=p(SetorEmpresa)>}[P/L]),'#.##0,00;-#.##0,00')

Thanks guys!