topic how to exclude total list box for one chart in QlikView

how to exclude total list box for one chart

bvssudhakar — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: how to exclude total list box for one chart

Anonymous — Wed, 19 Sep 2018 07:10:03 GMT

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)

Re: how to exclude total list box for one chart

tresB — Wed, 19 Sep 2018 07:12:08 GMT

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.

Re: how to exclude total list box for one chart

bvssudhakar — Wed, 19 Sep 2018 07:25:42 GMT

Hi,

Both gave same & correct answer. Thank you very much