Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

caio_caminoski
Contributor

[Sense] Pivot Table hide Null/Zero problem

Hi everyone!

I have a problem that seem really basic and I have no idea how to solve it.

I have a pivot table in my application. The problem is that it is showing a null row/column I can't hide.

Null Row.JPG

I have tried to change all dimension to sth like: "if( not isnull([Field]), [Field])" and my expression to "Sum( {<Qtd -= {'','0'}>} Qtd )"

No need to say that the option 'Show null values" is unabled

If someone have an idea, I would appreciate.

Thank you in advance!!

Caio Caminoski

Tags (3)
8 Replies
adellcom
New Contributor II

Re: [Sense] Pivot Table hide Null/Zero problem

Hello there
Do you know of a solution to this problem?

[His] Özet Tablo gizlemek Boş / sıfır problem


sureshqv
Esteemed Contributor III

Re: [Sense] Pivot Table hide Null/Zero problem

data handling tab

condition  like below

yourexprssion>0

adellcom
New Contributor II

Re: [Sense] Pivot Table hide Null/Zero problem

But the value does not turn to zero. The group name in the line returns null.


caio_caminoski
Contributor

Re: [Sense] Pivot Table hide Null/Zero problem

I think your field is blank and not null.

Maybe if you do in your script:

If( LEN(TRIM(HesapAd)) > 0, HesapAd  ) AS HesapAd


Then you can ignore nulls in the HesapAd dimension.


Regards,


Caio

adellcom
New Contributor II

Re: [Sense] Pivot Table hide Null/Zero problem

we are getting an error.


tmp:

load [Grup Ad] AS "GrupAd",

     [Hesap Ad] AS "HesapAd",

     Sum(Tutar) as "TmpTutar"

Resident Data

where [Grup Ad] like ('A*') or [Grup Ad] like ('B*')

group by  [Grup Ad], [Hesap Ad];

Concatenate

load 'Net Satış' AS "GrupAd",

     If( LEN(TRIM([Hesap Ad])) > 0, [Hesap Ad]  ) AS HesapAd2,

     Sum(Tutar) as "TmpTutar"

Resident Data

where [Grup Ad] like ('A*');

Concatenate

load 'Net Satış' AS "GrupAd",

     If( LEN(TRIM([Hesap Ad])) > 0, [Hesap Ad]  ) AS HesapAd2,

     Sum(Tutar*-1) as "TmpTutar"

Resident Data

where [Grup Ad] like ('B*');

tmp2:

load [Grup Ad] From_Field (tmp,[Grup Ad]);

drop Table [Data];

adellcom
New Contributor II

Re: [Sense] Pivot Table hide Null/Zero problem

no syntax error, but Pivot line is null again.

tmp:

load [Grup Ad] AS "GrupAd",

     If( LEN(TRIM([Hesap Ad])) > 0, [Hesap Ad]  ) AS HesapAd2,

     Sum(Tutar) as "TmpTutar"

Resident Data

where [Grup Ad] like ('A*') or [Grup Ad] like ('B*')

group by  [Grup Ad], [Hesap Ad];

Concatenate

load 'Net Satış' AS "GrupAd",

     '' AS HesapAd2,

     Sum(Tutar) as "TmpTutar"

Resident Data

where [Grup Ad] like ('A*');

Concatenate

load 'Net Satış' AS "GrupAd",

     '' AS HesapAd2,

     Sum(Tutar*-1) as "TmpTutar"

Resident Data

where [Grup Ad] like ('B*');

drop Table [Data];

caio_caminoski
Contributor

Re: [Sense] Pivot Table hide Null/Zero problem

You are concatenating blank registers. Then try the following:

tmp:

load [Grup Ad] AS "GrupAd",

      [Hesap Ad]  AS HesapAd,

     Sum(Tutar) as "TmpTutar"

Resident Data

where [Grup Ad] like ('A*') or [Grup Ad] like ('B*')

group by  [Grup Ad], [Hesap Ad];

Concatenate

load 'Net Satış' AS "GrupAd",

     NULL() AS HesapAd,

     Sum(Tutar) as "TmpTutar"

Resident Data

where [Grup Ad] like ('A*');

Concatenate

load 'Net Satış' AS "GrupAd",

     NULL() AS HesapAd,

     Sum(Tutar*-1) as "TmpTutar"

Resident Data

where [Grup Ad] like ('B*');

drop Table [Data];

adellcom
New Contributor II

Re: [Sense] Pivot Table hide Null/Zero problem


Could you please. Can you work on QVF? He's very grateful.

XXX.qvf - Google Drive

Table.xlsx - Google Drive

NET TUTAR will not break. The only future.

Community Browser