
Contributor III
2018-10-10
09:03 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Pivot table show item label in tabular form
Hi,
Is there any property of Pivot chart in Qlik Sense capable to do the same thing as Excel to show item label in tabular form?
I have SKU# and SKU name in the pivot table. I like those two data to be displayed at the same line not in the default hierarchy.
2,251 Views
2 Replies

Partner - Champion III
2018-10-11
01:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You could concatenate the two dimensions and use them as a single dimension by using this as a dimension expression:
=[SKU#] & ' - ' & [SKU]
2,193 Views

Contributor III
2018-10-18
09:00 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I found out the uncheck the Indent Rows option under Presentation did the trick.
