Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
settu_periasamy
Master III
Master III

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.

View solution in original post

2 Replies
settu_periasamy
Master III
Master III

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
Author

Thanks it worked !