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

Hiding values with under 30 responses in a pivot table

I currently have a pivot table displaying Averages for some Topics.

I was wondering if there was a way to have the cells come back as blank if there are under 30 survey responses?

Thanks!

Jordan

1 Reply
lcontezini
Partner - Creator
Partner - Creator

I don't know your data model, but I guess you could use a condition like:

if(

     [Number of Survey Responses] < 30,

                                                                 null(),

                                                                 [Average Expression]

)