Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

how to exclude total list box for one chart

Hi Experts,

I have a stacked bar chart and two list boxes Named as year and Fyear. My requirement is whenever i have selected from the year list box that stacked bar chart will unresponsive (Means list box year selections will not apply to this chart)

These are my expression for my chart:

=count({<Recruiter={'Irfan Memon','Rajiv Ranjan','Aditi Saxena','Sneha Singh'},Date_Flag={'plcdate'},fYear={2018,2019}>}CandidateID)

=count({<Recruiter={'Irfan Memon','Rajiv Ranjan','Aditi Saxena','Sneha Singh'},Date_Flag={'offerdate'},fYear={2018,2019}>}CandidateID)

what should i modify/add in my expressions to that

Please help me out from this

Thank you in advance

1 Solution

Accepted Solutions
Anonymous
Not applicable

ad year= to your Expression in set Analysis

=count({<year=,Recruiter={'Irfan Memon','Rajiv Ranjan','Aditi Saxena','Sneha Singh'},Date_Flag={'plcdate'},fYear={2018,2019}>}CandidateID)

View solution in original post

3 Replies
Anonymous
Not applicable

ad year= to your Expression in set Analysis

=count({<year=,Recruiter={'Irfan Memon','Rajiv Ranjan','Aditi Saxena','Sneha Singh'},Date_Flag={'plcdate'},fYear={2018,2019}>}CandidateID)

tresesco
MVP
MVP

Include the year field as well in the set analysis like:

=count({<YearField, Recruiter={'Irfan Memon','Rajiv Ranjan','Aditi Saxena','Sneha Singh'},Date_Flag={'plcdate'},fYear={2018,2019}>}CandidateID)


Similarly in other expression as well.

bvssudhakar
Creator III
Creator III
Author

Hi,

Both gave same & correct answer. Thank you very much