how to exclude total list box for one chart

[bvssudhakar]

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

[Anonymous · Accepted solution]

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]

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]

Hi,

Both gave same & correct answer. Thank you very much