Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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
Hi,
PFA.
Method1: try to use alternate state (refer to the attachment)
method2: ignore list box field selection from chart object.
@
Like this you want?
Can you show Method 2 in qvw ?
Min of EngineVsToner should reflect in chart
Hi,
may be this
Sum({<[Engine/Toner]>} A)
Regards,
Antonio
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..
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
Hey Pradosh.. Thank you!! Works perfect as expected