topic Re: Problem with graphic and null values in QlikView

Problem with graphic and null values

Fri, 02 Jan 2015 15:08:55 GMT

Hi everybody.

I'm having problems with null values in a graphic. The problem is this:

I have null values in my data. In the pivot table i can use the option "dont show null values"

but in the graphic, in the tag part, i can't do that.

For example in the pivot table i have "Total: 75000", in the graphic i have "Total:75200" (for the nulls)

I tried IF not is null(SUM(quantity)) but it's not working.

have i made myself clear?

Greetings!

jpenuliar — Fri, 02 Jan 2015 15:26:34 GMT

Hi,

Try below Set Analysis:

Sum({<YourFieldshowingnull = {'*'}-{''}>}Quantity)

Fri, 02 Jan 2015 15:36:15 GMT

Hi!

Im not sure if i understood.

This should be like this ?

Sum({<NULL FIELD = WHAT'S THIS? {'*'}-{''}>} QUANTITY)

Fri, 02 Jan 2015 15:39:19 GMT

It's Woking! Thank you.

But would you please explain the {'*'}-{''} part?

Greetings!

jpenuliar — Fri, 02 Jan 2015 15:40:51 GMT

This should be the field you used as Dimension

try your field "Razon social" or with "?olicitante".

jpenuliar — Fri, 02 Jan 2015 15:45:06 GMT

It's basically "All except null" modifier.