Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Highlighted
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)
6 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.
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.
Community Browser