Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
joeybird
Creator III
Creator III

Allow selections to amend table when table has set anyalsis assigned qlik sense

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

1 Reply
juliensaintmaxent3113
Luminary Alumni
Luminary Alumni

hi,

you do change the set analysis

try this:

Count({$<date_of_order = {">=$(=min(date_of_order)) <=$(=max(date_of_order))"}>}[OrderID])

bye