topic Re: Expression in QlikView

Expression

upaliwije — Sun, 24 Nov 2013 04:10:23 GMT

In my Pivot Table I have dimension field 'NOTE' ranging from 100 to 1000. I was to sum my fact field limiting note from 500 to 800 . Pls help me how to write this expression

Re: Expression

israrkhan — Sun, 24 Nov 2013 05:23:16 GMT

try like this,

Sum({<NOTE >=500 <=800>}FactField) or

Sum({<NOTE >=500, NOTE <=800>}FactField)

Re: Expression

upaliwije — Sun, 24 Nov 2013 05:36:12 GMT

it is not working

Sum({<NOTE >=500, NOTE <=800>}BUDGET)

Re: Expression

israrkhan — Sun, 24 Nov 2013 05:40:51 GMT

i think your field is text.

try like below

Sum({<NOTE >= {'500'}, NOTE <={'800'}>}BUDGET)

make sure NOTE is is Note. caps

Re: Expression

Sun, 24 Nov 2013 09:24:45 GMT

try this

Sum({<NOTE={'>=$(500)<=$(800)'}>}BUDGET)