topic Extra header in Pivot in QlikView

Extra header in Pivot

Anonymous — Sun, 03 May 2015 13:29:59 GMT

Hi Community

In my QV report I have custom objects like the attached(7x11.qvw)

and, I can achieve my result set but the expression is huge.

Is there any way I can get required report like the attached one, in another word simplifying expression.

I have numbers of object which are different than each other so I can not handle with INLINE.

I feel the attached report(7x11.qvw) is not right solution.

I found one very helpful example in QV community(Extra..QVW, Attached for reference); shared by John Witherspoon (Thanks John). But for that I need to create one INLINE table for each object. In my case this is not possible I create multiple INLINE tables.

QV to work on is 7x11.qvw

Please share/ suggest, I appreciate

Thanking you

Re: Extra header in Pivot

Gysbert_Wassenaar — Sun, 03 May 2015 15:00:21 GMT

To be honest I don't see much difference between creating lots of synthetic dimensions for each pivot table and creating an excel file with tables for each pivot table.

As for simplifying your expression. You can use pick-match combinations instead of nested ifs, but you will still have very big complicated expression.

Perhaps you simply do that kind of customized reporting in excel.

Re: Extra header in Pivot

Anonymous — Sun, 03 May 2015 16:10:29 GMT

I understand Gysbert

Thanks

Re: Extra header in Pivot

petter — Sun, 03 May 2015 16:18:42 GMT

This I hope will point you in the right direction - yes it is possible to simplify a lot - by taking full advantage of the Associative Data Model in QlikView - find also attached a revised QVW that demos what is screenshots underneath:

Re: Extra header in Pivot

Anonymous — Sun, 03 May 2015 18:49:23 GMT

Hi Petter

I appreciate your suggestion, which is helpful

Thanks