topic Re: Null Values in straight table in QlikView

Null Values in straight table

Thu, 25 Feb 2016 19:42:42 GMT

Hello Qlikview experts,

I am having a little bit of a problem with one of my qlikview charts.

The chart is a straight table, it has several dimensions and expressions. All the dimensions have Suppress when value is null checked.

When i complete loading this chart there are still simensions where the value of the dimension is null.

I went into the presentation tab and made sure that i supress null values for each dimension but this still does not effect the chart i am building.

I am unsure as to how i can eliminate it from my chart. Is there anything i am missing or something i misunderstood

Any help in this regard would be extremely helpful.

Thanks,

Sai

Re: Null Values in straight table

sunny_talwar — Thu, 25 Feb 2016 21:00:39 GMT

Are you sure its null (should have a small negative '-' sign if its a null dimension) or do you have a white space which makes you think its null?

Re: Null Values in straight table

Thu, 25 Feb 2016 21:13:56 GMT

I tried using isnull function on that particular field when i select that value from the list box.

it returns 0 representing it is not null.

I tried finding the length of it and it shows the length to be 0.

i figured it might be something with just space and tried to trim the extra spaces.

but i am at a loss. If it is not null or does not have any spaces there then how do i get a value out of it.

Re: Null Values in straight table

psankepalli — Thu, 25 Feb 2016 21:18:26 GMT

if you Feel those are NULL values try to replace it with NA value and confirm it, whether those values are NULLs or not?

Re: Null Values in straight table

Clever_Anjos — Thu, 25 Feb 2016 21:20:22 GMT

Would you mind sharing your app?

Preparing examples for Upload - Reduction and Data Scrambling

Re: Null Values in straight table

Thu, 25 Feb 2016 21:25:47 GMT

I am afraid i cannot be sharing the application.

Re: Null Values in straight table

sunny_talwar — Thu, 25 Feb 2016 23:34:45 GMT

May be in the script use KeepChar()

KeepChar(FieldName, 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789') as FieldName

May be add special character if you field have them, else you can leave them.

Re: Null Values in straight table

Peter_Cammaert — Thu, 25 Feb 2016 23:55:32 GMT

You could try changing each dimension into a Calculated Dimension by entering an expression like:

=IF (len(trim(ThisDimensionField)) > 0, ThisDimensionField)

which will convert all empty string-values and strings containing only whitespace into real NULL values that get suppressed by your marking the "Suppress When Value is Null" checkbox.