Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display records

Hello

In a pivot table,  I only want to display the records where for each item in the field “Besteknummer”
there are the items “Goedkeuring bestek” and “Gunning van de opdracht” in the field “Etappe tekst”.

How can I achieve that ?

Thanks in advance
Marc

2 Replies
swuehl
MVP
MVP

A chart like a pivot table is used to aggregate records grouped by dimensions. So if you want to display records, you'll need to add a dimension that is unique on the lowest level you want to see, i.e. record level. So you probably need to add something like a RecId to your data model and your chart dimensions. Then you can filter your records using conditionals or adding a set expressionset in the aggregation function.

Not applicable
Author

Hi

Thanks a lot for the information

Marc