Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Partner - Creator III
Partner - Creator III

hi,

you do change the set analysis

try this:

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

bye