Sub Headers in the straight or pivot table

[#1]

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

[settu_periasamy · Accepted solution]

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.

[#3]

Thanks it worked !