topic Dynamic Header/Label in Pivot Table in QlikView

Dynamic Header/Label in Pivot Table

Mon, 21 Mar 2016 09:00:54 GMT

Hi All,

I'm having a hard time creating the report format below:

Just want to ask if this is possible? When I put in the months, I'm having trouble making the LABEL dynamic.. If I make the label dynamic and create multiple formulas (7 formulas), the months repeat.. is there a way to hide/workaround that I can do to achieve this report format?

Thanks,

Donat

Re: Dynamic Header/Label in Pivot Table

avinashelite — Mon, 21 Mar 2016 09:53:53 GMT

check this

multi_header_pivot_import.qvw

Re: Dynamic Header/Label in Pivot Table

Gysbert_Wassenaar — Mon, 21 Mar 2016 10:00:07 GMT

You can't make the expression column headers dynamic. If you want such headers you'll have to use text boxes and place them on top of the pivot table.

Re: Dynamic Header/Label in Pivot Table

Tue, 22 Mar 2016 01:26:47 GMT

so that's the only workaround ;(

Re: Dynamic Header/Label in Pivot Table

jagan — Tue, 22 Mar 2016 01:31:13 GMT

Hi,

You can try ValueList() as the dimension, it is not possible with the existing features.

Regards,

Jagan.

Re: Dynamic Header/Label in Pivot Table

Tue, 22 Mar 2016 03:30:23 GMT

is there any possibility when I send to excel I'll be able to insert rows above

Re: Dynamic Header/Label in Pivot Table

jagan — Tue, 22 Mar 2016 05:35:41 GMT

You have to try macro, but it is very difficult. Can you attach some sample data so that it would be easier to give a try.

Regards,

Jagan.