Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

yoganantha321
Contributor II

How to hide the first row in straight table

Hi all,

I have a data like as shown below,

IDValue
15
210
315
420

 
But i need to show in straight table as Sum Value (adding with previous value

I am getting the output as 

IDValueSum Value
15 
21015
31530
42050

 

My expected output should be like below 

IDValueSum Value
21015
31530
420

50

Labels (1)
7 Replies
pradosh_thakur
Honored Contributor II

Re: How to hide the first row in straight table

where len(trim([Sum Value])) >0 
where [Sum Value] >0 
Learning never stops.
yoganantha321
Contributor II

Re: How to hide the first row in straight table

Hi Thakur,

Sum Value is an expression

pradosh_thakur
Honored Contributor II

Re: How to hide the first row in straight table

Hi Yoganantha

I know [Sum Value] is an expression but you must have given an alias to it. Use where clause on top of it.

Thanks
Pradosh

Learning never stops.
pradosh_thakur
Honored Contributor II

Re: How to hide the first row in straight table


load *
where len(trim([Sum Value])) >0 ;
load * , ...... as [Sum Value]
from table_name'
Learning never stops.
Highlighted
yoganantha321
Contributor II

Re: How to hide the first row in straight table

Thanks

pradosh_thakur
Honored Contributor II

Re: How to hide the first row in straight table

Welcome. If this is resolved , please close the thread.

Learning never stops.
qv_testing
Valued Contributor II

Re: How to hide the first row in straight table

try this..

RangeSum(Above(Sum([Value]), 0, RowNo(TOTAL)))

or

RangeSum(Above(Sum([Value]), 0, RowNo()))