topic Re: Problem with null values in pivot chart in QlikView

Problem with null values in pivot chart

saimahasan — Wed, 23 Nov 2016 08:47:38 GMT

Hi All,

I have a pivot chart wherein i have made all 0's as null in my expression.

Now when i am trying to suppress null values, its not suppressing the row when its all nulls in that row.

Please find below the screenshot for my problem statement.

Since "Structured Rates" and "Non FIC" are non null in CYTD16 dimension value, its not even suppressing these columns under CYTD17 dimension values also.

Please help.

Re: Problem with null values in pivot chart

MK_QSL — Wed, 23 Nov 2016 09:57:06 GMT

Provide sample file or sample app.

Re: Problem with null values in pivot chart

dineshm030 — Wed, 23 Nov 2016 09:59:13 GMT

Hi,

Please attach your QVW.

Re: Problem with null values in pivot chart

saimahasan — Wed, 23 Nov 2016 10:21:16 GMT

I cannot share the sample app since it has confidential data.

In general terms, if you all can suggest what can be done??

I have explicitly made the expression value as null wherever it comes to 0 by using null().

Now when i am suppressing Null values from dimensions tab, i am not able to suppress those rows where i have explicitly made them null.

Re: Problem with null values in pivot chart

MK_QSL — Wed, 23 Nov 2016 10:35:06 GMT

Yes.. you can't share confidential data.

But you can create few lines of dummy data and can share here.