Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Dynamic Header/Label in Pivot Table

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

Tags (1)
6 Replies

Re: Dynamic Header/Label in Pivot Table

Re: Dynamic Header/Label in Pivot Table

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.


talk is cheap, supply exceeds demand
Not applicable

Re: Dynamic Header/Label in Pivot Table

so that's the only workaround ;(

MVP
MVP

Re: Dynamic Header/Label in Pivot Table

Hi,

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

Regards,

Jagan.

Not applicable

Re: Dynamic Header/Label in Pivot Table

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

MVP
MVP

Re: Dynamic Header/Label in Pivot Table

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.

Community Browser