Independent Charts

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

Hello!

This is Bruno again with a new doubt.

I have created the following charts and they were supposed to be independent. I mean, it doesn't matter if the user selects or not something, the chart is supposed to say there, with absolutely no changes.

The Dimension is: =Date(DACG, 'DD/MM/YY')
The Expression is: =avg({1 <STCK={'GOLL4'}, DACG={">$(=Date(Addmonths(Today(), -3)))"}>} VDAF)

And I have a color-changing expression, that is: =If(firstsortedvalue(TOTAL {<STCK={'CCRO3'}>} VDAF, -DVPG, 1) > firstsortedvalue(TOTAL{<STCK={'CCRO3'}>} VDAF, -DVPG, 2), color(3), color(2))

So, basically, if the user selects something on a Lisbox using the STCK Field, nothing happens, and it's good!

But, if the user selects something from any other field, like SUBS (Subsector) for example, than the whole charts changes.

What should I do to let it static?
With no changes at all?

Thanks
Bruno Lelli

Re: Independent Charts

Lisa_P — Wed, 27 May 2020 04:51:54 GMT

Just insert the 1 inside the {} like your expression.

If(firstsortedvalue(TOTAL {1<STCK={'CCRO3'}>} VDAF, -DVPG, 1) > firstsortedvalue(TOTAL{1<STCK={'CCRO3'}>} VDAF, -DVPG, 2), color(3), color(2))

Re: Independent Charts

brunolelli87 — Wed, 27 May 2020 13:28:05 GMT

Ohhh, thanks!

I really forgot about that!!!

Thank you so much!

topic Re: Independent Charts in QlikView

Independent Charts

Re: Independent Charts

Re: Independent Charts