topic Returning only specific field from chart in QlikView

Returning only specific field from chart

Michel564 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Returning only specific field from chart

dplr-rn — Thu, 25 Jul 2019 21:17:20 GMT

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)

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

Re: Returning only specific field from chart

Michel564 — Fri, 26 Jul 2019 13:03:30 GMT

Thank You

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

Re: Returning only specific field from chart

dplr-rn — Fri, 26 Jul 2019 13:05:17 GMT

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

Re: Returning only specific field from chart

Michel564 — Fri, 26 Jul 2019 13:14:06 GMT

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