topic Re: Straight table issue. in QlikView

Straight table issue.

Wed, 25 Nov 2020 16:16:04 GMT

I have below expression in straight table with one dimension.This expression will give different numbers when I do expression total and sum of rows.Not sure why.

IF(Key='200',sum([Area]),

(Sum([Area]) + Sum({$<[Type]={'Sub'}>}([Area]*-1))))

Thanks Much.

Re: Straight table issue.

Gysbert_Wassenaar — Mon, 19 Sep 2016 11:26:36 GMT

It's because the test Key='200' from the if statement can't be done at the total level. It can only be done at the record level. Key has no singe value at the chart total level.

Re: Straight table issue.

stabben23 — Mon, 19 Sep 2016 12:20:52 GMT

Try this Expression:

sum(aggr(IF(Key='200',sum([Area]),Sum([Area]) + Sum({$<[Type]={'Sub'}>}([Area]*-1)))),'Your dimension'))