topic Re: Count on Set analysis expression with dates as if condition in QlikView

Count on Set analysis expression with dates as if condition

Anonymous — Thu, 16 Aug 2018 10:04:03 GMT

Find the below table as sample:

I have this set analysis expression " Count({<MachDatekey = {"=design_accept = 3"}>} DISTINCT MachDatekey) "to count distinct MachdateKey if design_accept=3 for all rows of that MachDateKey.

Now I have included Date field in the input data as I have another version of data for the same MachDateKey.

How can I include the Datefield in the above set analysis expression for getting the same result by considering 8/7/2018 as minimum date and 8/14/2018 as maximum date ?

Re: Count on Set analysis expression with dates as if condition

michaelsikora — Thu, 16 Aug 2018 12:40:24 GMT

May be try this:

Count(DISTINCT {<MachDatekey = {"=design_accept = 3"}, DateField ={">=$(=today()-7)) <=$(=today()-1))"}

>} MachDatekey)

If you want you can replace today()-7 with a specific date '8/7/2018' depending on your format for date.

Re: Count on Set analysis expression with dates as if condition

jonathandienst — Thu, 16 Aug 2018 12:50:09 GMT

Doesn't the simple expressions work?

Count({<design_accept = {3}>} DISTINCT MachDatekey)

Use this in a table/chart with Date as a dimension.

Re: Count on Set analysis expression with dates as if condition

Anonymous — Thu, 16 Aug 2018 13:53:10 GMT

I can't because that will become the third dimension.

Re: Count on Set analysis expression with dates as if condition

Anonymous — Fri, 17 Aug 2018 05:22:53 GMT

I got the expression.

Thanks all