Solved: Is it possible?Second header - Qlik Community

Report Inappropriate Content · ‎2010-04-13

I have created a pivot table with a Few Expressions

Expr1

Expr2

Expr3

Expr4.....

I want to create a header to enclose Expr1 and Expr2, and another one for the other.

Is it possible?

Header1		Header2
Expr1	Expr2	Expr3	Expr4

Best regards

d_pranskus · ‎2010-04-13

Hi

There is no straightforward way to do it. But here is some workaround. You should create an island table for your columns and headers and then create just one expression which calculates desired value depending on dimension from island table

Cheers

Darius

View solution in original post

d_pranskus · ‎2010-04-13

Hi

There is no straightforward way to do it. But here is some workaround. You should create an island table for your columns and headers and then create just one expression which calculates desired value depending on dimension from island table

Cheers

Darius

johnw · ‎2010-04-13

Yep, that's how I do it too. Seems like a good approach.

Report Inappropriate Content · ‎2010-04-14

thanks Darius

very nice

Report Inappropriate Content · ‎2010-05-26

Has anyone put this in as a feature request for version 10? This seems to be a common issue faced when migrating reports from excel to Qlikview.