topic Restrict dimension value in QlikView

Restrict dimension value

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

Hi all,

I have the following issue : in a bar chart i want display all value for my dimension Age, even if count is null. So, it's ok (see the snapshot below).

But i'd like to restrict only Age>=27. When i put as dimension =if(AGE>=27,AGE) it remove null value like 51, 53,54,55 even if i uncheck "suppress null value".

Is there a way to fix it?

Thanks

Re: Restrict dimension value

sunny_talwar — Tue, 17 Apr 2018 12:23:59 GMT

Would you be able to share a sample or image to show the issue?

Re: Restrict dimension value

jaumecf23 — Tue, 17 Apr 2018 12:24:28 GMT

You can try to not modify the dimension and force it in the Expression. Something like this:

Expression : sum({<AGE={">=27"}>}Amount)