Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
Thank You
The If/Then Statement worked when I put it in the right place!
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
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