topic Re: How to limit dimension value in staright chart in QlikView

How to limit dimension value in staright chart

vipingarg23 — Fri, 13 Oct 2017 08:17:18 GMT

I have dimension called Status which has below Values:

OPEN

INPROGRESS

I want to see the status with OPEN status only. I am using below expression but it is not working:

If(Status='OPEN',Status)

Can anybody help me out there?

Anil_Babu_Samineni — Fri, 13 Oct 2017 08:19:33 GMT

The above one should work. OR

If(Match(Status, 'OPEN'), Status) and then suppress from dimension

vipingarg23 — Fri, 13 Oct 2017 08:32:16 GMT

It is also not working. It is also showing same behaviour as If. It is applying only for first value.

If I write, If(Status='CLOSE',Status) then it is working fine but for open and inprogress, it is not working well.

rubenmarin — Fri, 13 Oct 2017 08:33:56 GMT

Hi Vipin, maybe it's showing the other status values because there is other expressions in the chart.

With only that expression, and having status as chart dimension it should work.

Anil_Babu_Samineni — Fri, 13 Oct 2017 08:34:20 GMT

Can you check the OPEN spelling because Qlik is case sensitive

rubenmarin — Fri, 13 Oct 2017 08:37:37 GMT

Can you give more details on what's happening with 'open' and 'inprogress', and the expected result?

For status='CLOSE' it should show 'CLOSE', and Null() for other status.

vipingarg23 — Fri, 13 Oct 2017 08:37:37 GMT

Spelling is fine Anil..

vipingarg23 — Fri, 13 Oct 2017 08:38:32 GMT

You are right Ruben. So is there any other way..So that I can only see OPEN status data in chart.

vipingarg23 — Fri, 13 Oct 2017 08:39:31 GMT

Yes..It is showing the same behaviour.

rubenmarin — Fri, 13 Oct 2017 08:44:13 GMT

Can have an impact in performance, but you can try with a calculated dimension, instead of the field Status, you can add the dimension:

Aggr(If(Status='OPEN',Status), Status)

You should check to 'Supress null values' in this dimension.

Another way is adding the condition to check Status='OPEN' in all expressions of the chart.

vipingarg23 — Fri, 13 Oct 2017 08:49:51 GMT

Yes..Right..It worked fine now...Thanks for clarification Ruben.