Set Analysis Question

rustyfishbones — Fri, 22 Sep 2017 18:24:30 GMT

Hi All,

Is it possible to use Set Analysis within Set Analysis.

Like this example, which does not work

COUNT(DISTINCT {<SNAPSHOT_DATE = {">=$(=Date(MAX({<SNAPSHOT_DATE -= {'16/09/2017'}>}SNAPSHOT_DATE)-20,'DD/MM/YYYY'))"},FileType = {'HISTOPEN'}>}[Service Request Number])

This part works fine

COUNT(DISTINCT {<SNAPSHOT_DATE = {">=$(=Date(MAX(SNAPSHOT_DATE)-20,'DD/MM/YYYY'))"},FileType = {'HISTOPEN'}>}[Service Request Number])

I would like to count the Service Request Numbers for the last 20 days, but not include data for a specific date within those 20 days, can it be done in an expression using set analysis?

Regards

Alan

Re: Set Analysis Question

sunny_talwar — Fri, 22 Sep 2017 18:45:38 GMT

May be this

Count(DISTINCT {<SNAPSHOT_DATE = {">=$(=Date(MAX(SNAPSHOT_DATE)-20, 'DD/MM/YYYY'))"}-{'16/09/2017'}, FileType = {'HISTOPEN'}>} [Service Request Number])

Re: Set Analysis Question

rustyfishbones — Fri, 22 Sep 2017 18:54:41 GMT

Yes, that's it, perfect

topic Set Analysis Question in QlikView

Set Analysis Question

Re: Set Analysis Question

Re: Set Analysis Question