topic Re: Hide Sub Total If value is Zero in QlikView

Hide Sub Total If value is Zero

gopikrishnach — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Here am attaching my qvw file, in i have data and created pivot tables,

Here i want the sub total value and sub total not equal to 0.

If sub total is zero then it should not reflect in Chart.

Please guide me how to do.

Re: Hide Sub Total If value is Zero

sunny_talwar — Sun, 11 Dec 2016 21:39:18 GMT

So you only want the total row to disappear here? But still want to see the individual row with 0s?

Re: Hide Sub Total If value is Zero

gopikrishnach — Sun, 11 Dec 2016 21:50:41 GMT

Yes, I don't want row which are having value=0

Re: Hide Sub Total If value is Zero

sunny_talwar — Sun, 11 Dec 2016 21:51:23 GMT

rows or total rows?

Re: Hide Sub Total If value is Zero

sunny_talwar — Sun, 11 Dec 2016 21:52:41 GMT

Selecting 'Suppress Zero-Values' on the Presentation tab removed all the rows with 0

Re: Hide Sub Total If value is Zero

gopikrishnach — Sun, 11 Dec 2016 21:54:23 GMT

i don't want sub Total Value which are having zero.

Example: i want display the material name with zero, but i don't want the rows which are having the sub Total as zero.

Re: Hide Sub Total If value is Zero

gopikrishnach — Sun, 11 Dec 2016 22:00:08 GMT

if i pick the Suppress Zero-Values the entire table is not coming,

Example: i want display the material name with zero, but i don't want the rows which are having the sub Total as zero.

Re: Hide Sub Total If value is Zero

sunny_talwar — Sun, 11 Dec 2016 22:12:59 GMT

Here you go

Expression:

If(Sum(DAY_VALUE) = 0, If(Dimensionality() = 2, Num(0.00000000001, '##.')), Sum(DAY_VALUE))

Re: Hide Sub Total If value is Zero

gopikrishnach — Sun, 11 Dec 2016 22:24:16 GMT

I got it. Thank you Sunny T

Re: Hide Sub Total If value is Zero

gopikrishnach — Sat, 17 Dec 2016 06:29:08 GMT

Here i have one more condition, if the count(material) is ">"0, then only i want the sub total. Please review.

Re: Hide Sub Total If value is Zero

Anil_Babu_Samineni — Sat, 17 Dec 2016 17:41:26 GMT

Might Sunny busy with some other work

Do you mean this?

Expression 1 by using simple

If(Count(material) >0, Sum(DAY_VALUE))

Expression 2 by Using Set Analysis

Sum({<material = {'=Count(material) > 0'}>} DAY_VALUE)

Re: Hide Sub Total If value is Zero

gopikrishnach — Sat, 17 Dec 2016 17:57:47 GMT

No, i want to club both above condition in one expression.

Re: Hide Sub Total If value is Zero

Anil_Babu_Samineni — Sat, 17 Dec 2016 18:12:57 GMT

This?

1) If(Sum({<MATERIAL={"=count(MATERIAL)>0"}>} DAY_VALUE) = 0, If(Dimensionality() = 2, Num(0.00000000001, '##.')), Sum({<MATERIAL={"=count(MATERIAL)>0"}>} DAY_VALUE))

2) If(Sum({<MATERIAL={"=count(MATERIAL)>0"}>} MTD_VALUE) = 0, If(Dimensionality() = 2, Num(0.00000000001, '##.')), Sum({<MATERIAL={"=count(MATERIAL)>0"}>} MTD_VALUE))

3) If(Sum({<MATERIAL={"=count(MATERIAL)>0"}>} YTD_VALUE) = 0, If(Dimensionality() = 2, Num(0.00000000001, '##.')), Sum({<MATERIAL={"=count(MATERIAL)>0"}>} YTD_VALUE))

Updated Image

Re: Hide Sub Total If value is Zero

Anil_Babu_Samineni — Sat, 17 Dec 2016 18:16:40 GMT

I updated above, Please check enclosed attachment if need

Re: Hide Sub Total If value is Zero

gopikrishnach — Tue, 20 Dec 2016 05:48:07 GMT

Anil, i tried with the above expression, but for all materials am getting the Total Values.

Below is my Condition.

If only one Material is present and Material Description is (null) not available in the respective Table, don't want the sub total, If more than one material is available to the respective Indicator than i want the sub total.

I want to display the all Indicators irrespective of Material. i.,e, If material is available and Material Description is not present then it should display.

Please refer below post also...

How to Hide the Sub Filed/Null Filed in Pivot Table

Re: Hide Sub Total If value is Zero

gopikrishnach — Wed, 21 Dec 2016 15:51:52 GMT

Can anyone please help me how to club both conditions.