Bar Chart requirement

[bharani8]

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!!

[devarasu07]

Hi,

PFA.

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

method2: ignore list box field selection from chart object.

@

[prma7799]

Like this you want?

[bharani8]

Can you show Method 2 in qvw ?

[bharani8]

Min of EngineVsToner should reflect in chart

[antoniotiman]

Hi,

may be this

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

Regards,

Antonio

[bharani8]

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..

[pradosh_thakur · Accepted solution]

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

[bharani8]

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