Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Please use this in status Expression. Hope this is what you are expecting.
=if([Quarter Actual]<>0 and [Quarter Target]<>0 or [Quarter Actual]>[Quarter Target],'qmem://<bundled>/BuiltIn/led_g.png',
if([Quarter Actual]<>0 and [Quarter Target]<>0 ,'qmem://<bundled>/BuiltIn/led_r.png'))
Is this your data in Excel or Qlikview?
I see Pivot not Straight Table
in presentation tab
- uncheck suppress 0 values for str table chart (top)
- check suppress 0 for pivot chart (bottom)
Yes its a straight table. This is how it looks in Qlikview.
Thanks Massimo, let me work on your inputs.
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?
Please close this thread if you got your answer by marking the correct answer so that it will be helpful for others
Hi Sasidhar,
Sadly I am still looking for more options.
Hi
Please post your application
Sasi
More options means?
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.