topic Re: Bar Chart requirement in QlikView

Bar Chart requirement

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

Hi Experts - I have a quick clarification...

I have attached my qv file.. I have a Bar chart in which one expression is Total # of Engine's and in other expression it gives min value of "EngineVsToner".. All these are working fine as expected.. Now my requirement is... I have a List box on left side of my QVW (Engine/Toner list box).. When i click the items in that... my Bar chart should not reflect to that where as my Pivot should change accordingly .. How do i do that? Plz help for this solution other than "Alternate state".. Thanks!!

Re: Bar Chart requirement

devarasu07 — Tue, 03 Oct 2017 07:11:10 GMT

Hi,

PFA.

Method1: try to use alternate state (refer to the attachment)

method2: ignore list box field selection from chart object.

Re: Bar Chart requirement

prma7799 — Tue, 03 Oct 2017 07:12:04 GMT

Like this you want?

Re: Bar Chart requirement

bharani8 — Tue, 03 Oct 2017 07:14:13 GMT

Can you show Method 2 in qvw ?

Re: Bar Chart requirement

bharani8 — Tue, 03 Oct 2017 07:20:21 GMT

Min of EngineVsToner should reflect in chart

Re: Bar Chart requirement

antoniotiman — Tue, 03 Oct 2017 07:20:50 GMT

Hi,

may be this

Sum({<[Engine/Toner]>} A)

Regards,

Antonio

Re: Bar Chart requirement

bharani8 — Tue, 03 Oct 2017 07:23:22 GMT

I have already used Engine/Toner in my Set analysis to show one particular item out of that... So may be you can give a try in my qv file attached..

Re: Bar Chart requirement

pradosh_thakur — Tue, 03 Oct 2017 07:23:50 GMT

Min({<[Engine/Toner] = >} Aggr(sum({<[Engine/Toner] = {'EngineVsToner'}>} A),Part_No,Month)) ---> expression1

Sum({<[Engine/Toner] = {'Engine'}>}A) ---> expression 2

in bar chart.

regards

Pradosh

Re: Bar Chart requirement

bharani8 — Tue, 03 Oct 2017 07:29:10 GMT

Hey Pradosh.. Thank you!! Works perfect as expected