Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

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

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

Highlighted
Creator II
Creator II

Hi,

Both gave same & correct answer. Thank you very much