Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
yoganantha321
Creator II
Creator 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
Master II
Master II

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

Hi Thakur,

Sum Value is an expression

pradosh_thakur
Master II
Master II

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
Master II
Master II


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

Thanks

pradosh_thakur
Master II
Master II

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

Learning never stops.
qv_testing
Specialist II
Specialist II

try this..

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

or

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