topic Re: How to hide the first row in straight table in QlikView

How to hide the first row in straight table

yoganantha321 — Sat, 16 Nov 2024 04:29:41 GMT

Hi all,

I have a data like as shown below,

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

I am getting the output as

My expected output should be like below

pradosh_thakur — Mon, 11 Feb 2019 12:16:14 GMT

where len(trim([Sum Value])) >0

where [Sum Value] >0

yoganantha321 — Mon, 11 Feb 2019 12:21:28 GMT

Hi Thakur,

Sum Value is an expression

pradosh_thakur — Mon, 11 Feb 2019 12:32:25 GMT

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

pradosh_thakur — Mon, 11 Feb 2019 12:29:08 GMT

load *
where len(trim([Sum Value])) >0 ;
load * , ...... as [Sum Value]
from table_name'

yoganantha321 — Mon, 11 Feb 2019 13:10:59 GMT

Thanks

pradosh_thakur — Mon, 11 Feb 2019 13:13:53 GMT

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

Nagaraju_KCS — Tue, 19 Mar 2019 10:21:34 GMT

try this..

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

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