topic Re: Dont show row if next row is zero in QlikView

Dont show row if next row is zero

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

Hi all,

I have one requirement like below

PROJ	Phase	Start_Date	Exp 1	Exp 2	Exp 3	Exp 4	Exp 4	Exp 5	Exp 6\	Exp 7
1238	Phase 1	6/8/2016	0	0	0	0	1	0	0	0
1238	Phase 1	6/15/2016	0	0	0	0	0	0	0	0
1238	Phase 1	6/22/2016	0	0	0	0	0	0	0	0
1238	Phase 2	6/8/2016	1	1	0	0	1	1	1	1
1238	Phase 2	6/15/2016	1	1	0	0	0	1	1	1
1238	Phase 2	6/22/2016	1	1	0	0	0	1	0	1
1238	Phase 2	6/29/2016	1	1	0	0	0	1	1	0
1238	Phase 2	7/6/2016	0	1	0	0	0	0	1	1
1238	Phase 2	7/13/2016	0	0	0	0	0	0	1	0

In above data for Phase 1 take min start date i.e 6/8/2016 to that i m getting i count for exp 4 remaing i m not getting that is fine , if i see for nxt date 6/15/2016 all are zero for all exp. i dont want see this date mean i want to restrict this row and but nxt if i have any value in any exp i want see all dates if zero also no problem.

I hope u understand this .

How to achieve this , can any one tell me on this ?

Re: Dont show row if next row is zero

vishsaggi — Thu, 11 Aug 2016 04:15:22 GMT

May be try this?

Use straight table and add dimensions (First 3 fields)

and expressions all exp1, exp2......exp7.

In presentation tab check Suppress zero values. as show below

Re: Dont show row if next row is zero

subbareddykm — Thu, 11 Aug 2016 04:31:08 GMT

Thanks for ur responce but what i want is

But in yor case it will remove entaire row ,

My case

I should check Phase wise Max Date If max date is All zero remove and check Next date if it have value then show above all if it is zero .

Re: Dont show row if next row is zero

vishsaggi — Thu, 11 Aug 2016 14:06:42 GMT

Quite did not get you. Can you tell me from the above table you mentioned, what dates should not be visible and what needs to be visible please??

Re: Dont show row if next row is zero

qliksus — Fri, 12 Aug 2016 10:55:32 GMT

May be create a new expression which has values like

If ( (Exp1+Exp2+Exp3+Exp4+Exp5) =0 and below (Exp1+Exp2+Exp3+Exp4+Exp5) = 0 ,0,1)

And change the text color of this to white to hide the display