topic Re: Delete Null Without Dimension in QlikView

Delete Null Without Dimension

pgalvezt — Tue, 20 May 2014 16:39:35 GMT

Hello,

When I have a pivot table I check (Delete Nulls). I have one dimension cc1, Show many option and values (this is my expression Sum({<Año={'2014'}>}pp1_01)*-1 The pivot show all values when I check Delete Values the information is correct. But I have another sheet with many charts those charts doesn´t have dimenssion. So How I can delete the same nulls?

Thanks,

Re: Delete Null Without Dimension

pgalvezt — Tue, 20 May 2014 18:57:32 GMT

Any Help!

Thanks!!

Re: Delete Null Without Dimension

Anonymous — Tue, 20 May 2014 20:25:45 GMT

If you are refering to expressions you can try something like len(FIELD)>0 in the condition

Re: Delete Null Without Dimension

pgalvezt — Tue, 20 May 2014 20:29:31 GMT

Thanks for your reply,

I solve the problem using Isnull, And then with Where Condition.