Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Sub Headers in the straight or pivot table

image.png

Hi All,

I have this requirement of including header on top of pivot or straight table. Is it possible to include a header in the format shown above in qlikview

1 Solution

Accepted Solutions

Re: Sub Headers in the straight or pivot table

Hi,

Try this.

if you don't have the dimension for daily sales and monthly sales, create calculated dimension like

=valuelist ('daily sales','monthly sales')

In the expression

=pick (match (valuelist ('daily sales','monthly sales'),

             'daily sales','monthly sales'),daily sales expression 1,monthly sales expression1)

Like above you need to do 5 time(separate expression).

This gives idea.

2 Replies

Re: Sub Headers in the straight or pivot table

Hi,

Try this.

if you don't have the dimension for daily sales and monthly sales, create calculated dimension like

=valuelist ('daily sales','monthly sales')

In the expression

=pick (match (valuelist ('daily sales','monthly sales'),

             'daily sales','monthly sales'),daily sales expression 1,monthly sales expression1)

Like above you need to do 5 time(separate expression).

This gives idea.

Not applicable

Re: Sub Headers in the straight or pivot table

Thanks it worked !

Community Browser