Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi - Using Qlik Sense
I have the following set analysis
Count({$<date_of_order = {'>=$(=vPreviousMonthStart) <=$(=vPreviousMonthEnd)'}>}[OrderID])
this sets a count (number of orders) measure to the table - date of orders from e.g 01/01/2019 to 31/01/2019
however I want then the table to change if a person makes date of order filter selections
e.g. 01/01/2019 to 20/02/2019
I have tried to replace the $ with 1, but no joy
please help
hi,
you do change the set analysis
try this:
Count({$<date_of_order = {">=$(=min(date_of_order)) <=$(=max(date_of_order))"}>}[OrderID])
bye