Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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