Skip to main content

Qlik Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Sept. 27, 10AM ET Do more with Qlik, Insight Advisor – our intelligent AI-assistant in Qlik Sense: Register
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
FinancialDataScientist
Contributor II
Contributor II
‎2021-01-27 03:53 PM

IF STATEMENT LABEL NOT "-"

Hi All,

 

I'm trying to label a pie chart and I'd like it say "None" rather "-" when there is no data. My current formula for the data field is:

if(quartile='1','1st Quartile',if(quartile='2','"nd Quartile',if(quartile='3','3nd Quartile',if(quartile='4','4th Quartile')))).

 

I've attached a picture in case that helps.

Thanks in advance guys!

Labels (4)
Labels
Preview file
8 KB
391 Views
0 Likes
2 Replies
Anil_Babu_Samineni
MVP
MVP
‎2021-01-27 04:01 PM

Try this

if(quartile='1','1st Quartile',if(quartile='2','"nd Quartile',if(quartile='3','3nd Quartile',if(quartile='4','4th Quartile', 'none'))))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
384 Views
FinancialDataScientist
Contributor II
Contributor II
‎2021-01-28 10:35 AM
Author

Hi Anil, I have tried this but the it seems to still count a a number of entries as "-" rather than none on the pie chart. Do you know how to fix this?

Preview file
16 KB
347 Views
0 Likes