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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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