Returning only specific field from chart

[Michel564]

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 

[dplr-rn · Accepted solution]

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]

Thank You

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

[dplr-rn]

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]

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