Delete row if both actual and target values are zero

[#1]

Hi Gurus,

I have a question. In a straight table, there are 5 columns.

Column 1 merged column - Sales,

Column 2 is subcategory for internal sales(again a merged column)- has two values internal sales and external sales

Column 3 metric metric under each subcategory such paints, soaps, fertilizers etc.

Now when both month actual and month target are both 0 & 0, i dont want to show them or in short i want to delete those columns or not show them whichever is convenient. I believe I can achieve this in expressions by using if condition but since columns are merged, deletion looks like a problem.

So, how can i achieve this ?

In the example below, soap and detergent are both 0 and 0, i want to not show them.

[robert_mika]

Is this your data in Excel or Qlikview?

I see Pivot not Straight Table

[maxgro]

in presentation tab 

- uncheck suppress 0 values for str table chart (top)

- check suppress 0 for pivot chart (bottom)

[#4]

Yes its a straight table. This is how it looks in Qlikview.

Thanks Massimo, let me work on your inputs.

[#5]

Hi Robert,

Yes its a pivot table. So i cannot delete the rows in a pivot table? Is there any way I can achieve what i want with a pivot table?

[sasiparupudi1]

Please close this thread if you got your answer by marking the correct answer so that it will be helpful for others

[#7]

Hi Sasidhar,

Sadly I am still looking for more options.

[sasiparupudi1]

Hi

Please post your application

Sasi

[qlikviewwizard]

malaykhanwalkar‌

More options means?

[#10]

Hi,

I am uploading my application which has a table. Can someone help me remove rows where actual and target values are both 0 and 0.