Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

Pivot Table use dimension as an expression

Hi,

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
sunny_talwar

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

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

Not applicable
Author

Still does not work

Anil_Babu_Samineni

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)
sunny_talwar

Can you show us what you are seeing?