Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Restrict dimension values but show all of them

We use a field "Stage" to track where a sale is from start to finish. There are about 30 different values for Stage, but the main five are

00 - Lead, 20 - Sales Opp, 40 - Discovery, 60 - Solution, 80 - Forecast Sale.

My dimension is:

If(mixmatch(left(STAGE,2),'00','20','40','60','80')>=1, STAGE, Null()),

with "Suppress if value is null" selected. Works great, if the rep has a sale at every stage.(the only expression is "Sum(Forecast)")

However, if a rep has no opportunities at, say, 40, that value doesn't show up in the chart, eg:

fcast.PNG

I've unchecked "Suppress Zero Values" and "Suppress Missing" on the Presentation tab. Is there any way to show the missing stages with a total of $0?

10 Replies
sunny_talwar

Hahahaha ya