Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
zhuravlevleonid
Contributor II
Contributor II

How to create sections in experssions?

I mean i want to group my expressins like on this screenshot. It is necessary to add subtitles and titles.

Example.png

Thx in advance!

1 Solution

Accepted Solutions
Peter_Cammaert
Partner - Champion III
Partner - Champion III

An Excel-like set-up of Pivot table columns like that is not supported by default by QlikView. You'll need one or more "hacks" to accomplish a pivot table layout like this, like the one Clever suggested. No standard buttons to press or switches to flick.

See here for examples:

Headings that span multiple columns in a pivot table

Create table in QV with multiple header rows | Qlik Community

Merge headers in pivot table

View solution in original post

3 Replies
Clever_Anjos
Employee
Employee

You can use ValueList('Title 1','Title 2') as a fake dimension

zhuravlevleonid
Contributor II
Contributor II
Author

And how can i adjust it to the chosen columns? What will be the code for subtitles?

Peter_Cammaert
Partner - Champion III
Partner - Champion III

An Excel-like set-up of Pivot table columns like that is not supported by default by QlikView. You'll need one or more "hacks" to accomplish a pivot table layout like this, like the one Clever suggested. No standard buttons to press or switches to flick.

See here for examples:

Headings that span multiple columns in a pivot table

Create table in QV with multiple header rows | Qlik Community

Merge headers in pivot table