Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
bvssudhakar
Contributor 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
Partner
Partner

Re: how to exclude total list box for one chart

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

Re: how to exclude total list box for one chart

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

MVP
MVP

Re: how to exclude total list box for one chart

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

Re: how to exclude total list box for one chart

Hi,

Both gave same & correct answer. Thank you very much