I basically want to restrict my data within a range when there are no selections made to the year and month_year fields.
This condition works perfectly in tables and KPI objects, however, it behaves in a strange way in charts. When there are no selections made in the year and month_year fields, the only values shown are in the range determined in the set analysis, but, all the other dates still appear with zero values. Like shown in the image below.
Note that there are values for all periods in my data model.
Anyone has any insights on why this might be happening?
Re: Using condition to change expression on Qlik Sense charts
Hi Sunny, thank you for the fast answer.
Unchecking the box does work, however, it also hides zero values within the 12 months range I established. In the example below, my analysis ended up a little bit distorted because July and August don't show up.