topic Re: How to get pivot table based on a condition on a set analysis calculation that is available in a straight table in QlikView

How to get pivot table based on a condition on a set analysis calculation that is available in a straight table

vvira1316 — Tue, 29 Nov 2016 20:24:57 GMT

Hi,

I've following straight table where Aging - Request Date is calculated as per Expression provided below. I need to create a Pivot table as seen in second screen shot, which I'm unable to formulate. Any guidance will be a big help.

Calculations

Aging - Request Date

=Today() -
Max({<[Doc Status]={'New Request'}, [Is DF Document]={'No'},[Sub Doc Type]-={'VAL1', 'VAL2'},
[CP Doc: DocID]>}[Request Date])

Docs

=Count({<[Doc Status]={'New Request'}, [Is DF Document]={'No'},[Sub Document Type]-={'VAL1', 'VAL2'}>}[CP Doc: DocID])

Pivot Table Info

Will it be possible to create a pivot table of above data where Aging - Request Date is > 2?

Re: How to get pivot table based on a ccondition on a set analysis calculation that is available in a straight table

sunny_talwar — Tue, 29 Nov 2016 20:29:21 GMT

How about this:

=Sum(Aggr(If(Today() - Max({<[Doc Status] = {'New Request'}, [Is DF Document] = {'No'}, [Sub Doc Type] -= {'VAL1', 'VAL2'},
[CP Doc: DocID]>} [Request Date]) > 2, Count({<[Doc Status] = {'New Request'}, [Is DF Document] = {'No'}, [Sub Document Type] -= {'VAL1', 'VAL2'}>} [CP Doc: DocID])), Name, [Request Date]))

Re: How to get pivot table based on a condition on a set analysis calculation that is available in a straight table

vvira1316 — Tue, 29 Nov 2016 20:44:53 GMT

Hi Sunny,

Thanks for a quick reply. It worked.

Regards,

Vijay

Re: How to get pivot table based on a condition on a set analysis calculation that is available in a straight table

sunny_talwar — Tue, 29 Nov 2016 20:45:48 GMT

Super