Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
RimDataAnalyst
Contributor III
Contributor III

Add pastille to cells in pivot table

I want to add these small green or orange dots based on a very specific criterion and display it next to the value in the cell in a pivot table

it is possible to do it with QLik ? 

RimDataAnalyst_0-1691674696369.png

 

Labels (3)
3 Replies
Or
MVP
MVP

I believe there is no native option for this sort of thing, though third-party Pivot Table extensions may well include this sort of option.

You could concatenate unicode characters to work around this - for example, this will work:

=Avg(1) & '🔴'

RimDataAnalyst
Contributor III
Contributor III
Author

Even this doesn't work 😞 

Or
MVP
MVP

I tested it before posting and it works fine...