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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Michel564
Contributor
Contributor

Returning only specific field from chart

I am trying to return only one result from a chart I am doing this through enable conditional then typing in formula and checking off suppress when value is null 

I have tried :

IF (deal_level=‘145’,deal_level) 

I have also tried  only formula 

I am not sure what I am doing wrong- should I be adding calculated dimension as opposed to enable conditional and which formula should I use? 

 

Thank you 

Michele 

1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

Enable conditional is for hiding a column not to show specific values

You should be using

ideally set analysis e.g. Sum({<deal_level={‘145’}>}Sales)

or

calculated dimension-  IF (deal_level=‘145’,deal_level) 

View solution in original post

4 Replies
dplr-rn
Partner - Master III
Partner - Master III

Enable conditional is for hiding a column not to show specific values

You should be using

ideally set analysis e.g. Sum({<deal_level={‘145’}>}Sales)

or

calculated dimension-  IF (deal_level=‘145’,deal_level) 

Michel564
Contributor
Contributor
Author

Thank You

The If/Then Statement worked when I put it in the right place!

dplr-rn
Partner - Master III
Partner - Master III

Professional advise. dont use it as a practice. Try with set analysis.

if statement on dimensions and expressions should be last option in my opinion/experience

Michel564
Contributor
Contributor
Author

Good to know.. I will try set analysis today.  I did notice the run time increased by a few minutes with my If/Then.

Still fairly new to Qlik and really appreciate the tips