Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
bharani8
Creator III
Creator III

Bar Chart requirement

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

1 Solution

Accepted Solutions
pradosh_thakur
Master II
Master II

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

Learning never stops.

View solution in original post

8 Replies
devarasu07
Master II
Master II

Hi,

PFA.

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

method2: ignore list box field selection from chart object.

@

prma7799
Master III
Master III

Like this you want?

bharani8
Creator III
Creator III
Author

Can you show Method 2 in qvw ?

bharani8
Creator III
Creator III
Author

Min of EngineVsToner should reflect in chart

antoniotiman
Master III
Master III

Hi,

may be this

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

Regards,

Antonio

bharani8
Creator III
Creator III
Author

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
Master II
Master II

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

Learning never stops.

View solution in original post

bharani8
Creator III
Creator III
Author

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