topic Re: Condition Problem in QlikView

Condition Problem

Fri, 27 Sep 2013 17:14:04 GMT

Hello,

Im currently using some sums if the account balance is on some account that accumulate values.

Currently i use this expression:

RangeSum(Above(SUM({$< Account={'0',

'1',

'2',

'3',

'4',

'6',

'7',

'8',

9',

'10',

'11'}

>} [MXN_Amount BSEG])

,0, RowNo(TOTAL)))

I was wondering if its possible to do something like:

RangeSum(Above(SUM({$< Account >= '1' and Account <= '1000'

>} [MXN_Amount BSEG])

,0, RowNo(TOTAL)))

I havent been able to make this work

Any ideas?, comments?

MayilVahanan — Fri, 27 Sep 2013 17:19:25 GMT

Try like this

RangeSum(Above(SUM({<Account {">= 1 <= 1000">} [MXN_Amount BSEG]),0, RowNo(TOTAL)))

For Set analysis, please refer this

Its useful to learn abt set analysis

swuehl — Fri, 27 Sep 2013 17:20:49 GMT

Maybe like this

RangeSum(Above(SUM(

{$< Account = {">=1<=1000"} >}

[MXN_Amount BSEG])

,0, RowNo(TOTAL)))