topic Re: Help with set Analysis in QlikView

Help with set Analysis

Anonymous — Wed, 13 Dec 2017 15:54:18 GMT

Need to show last Months months data for current year and previous year present in the data. We have full name as the dimension , for each full name we have to count distinct of Document ID's ( DOCID). When user picks 2017 as year the Document count for 6 months should show from maximum of year month to 6 months. The tricky problem is for some Full names the data is not there for some months still it has to show the maximum year month.

let me know if you have any questions.

Re: Help with set Analysis

sunny_talwar — Wed, 13 Dec 2017 16:01:48 GMT

Max 6 months based on the max date available for each FULL_NAME? What is the expected output for the above sample you have provided when 2017 is selected in YEAR?

Re: Help with set Analysis

Anonymous — Wed, 13 Dec 2017 16:20:55 GMT

Sending QVW file for explanation

Re: Help with set Analysis

Anonymous — Wed, 13 Dec 2017 16:22:38 GMT

See the Attached app

Re: Help with set Analysis

sunny_talwar — Wed, 13 Dec 2017 17:06:49 GMT

May be try to ignore selection in your set analysis

=count({<YearMonth={">$(=MAX({<YearMonth, FULL_NAME>}YearMonth)-6)<$(=MAX({<YearMonth, FULL_NAME>}YearMonth)+1)"}>} distinct DOCID)