Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot Table use dimension as an expression


For a particular use case in my dashboard, I need to use a dimension as an expression in a pivot table, but when I use the dimension as an expression I don't get any results. For example: a dimension [Course Title] displays vale 'abc' when used as a dimension but when I used the same dimension as an expression using the formula =[Course Title], I get only '-'

Kindly advise!

4 Replies

May be there are more than one values... to check if this is true or not, try this

Concat(DISTINCT [Course Title], ', ')

Not applicable

Still does not work


You have only one Expression in Pivot Table. If it is string you must check the Suppress from Presentation tab

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

Can you show us what you are seeing?