Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I've been working with QlikSense recently and I've encountered an issue with two filters. The first filter is the data filter, which is meant to drive the dashboard. The second filter is for the products.
I've also created a table where everything is filtered by the data filter. So, when I select a date, the table displays all the values that precede the selected date, showing all the products that have a date <=DD/MM/YYYY. This can be confusing because I've only selected one parameter, and it affects my product filter.
Is there a way for me to display all the products with a date less than or equal to DD/MM/YYYY in the product filter, regardless of the date I've selected?
Thank you in advance.
Create product filter nd use below
{<DateField = {"<=$(=Max(DateField))"}>