Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
caio_caminoski
Creator
Creator

[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

8 Replies
adellcom
Contributor III
Contributor III

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

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


Chanty4u
MVP
MVP

data handling tab

condition  like below

yourexprssion>0

adellcom
Contributor III
Contributor III

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


caio_caminoski
Creator
Creator
Author

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
Contributor III
Contributor III

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
Contributor III
Contributor III

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
Creator
Creator
Author

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
Contributor III
Contributor III


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.