[Sense] Pivot Table hide Null/Zero problem

[caio_caminoski]

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.

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

[adellcom]

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

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

[Chanty4u]

data handling tab

condition  like below

yourexprssion>0

[adellcom]

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

[caio_caminoski]

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]

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]

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]

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]

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.