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

joeybird — Mon, 20 Dec 2021 21:38:40 GMT

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

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

juliensaintmaxent3113 — Mon, 04 Mar 2019 16:05:21 GMT

hi,

you do change the set analysis

try this:

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

bye