topic add constraint on calculation in QlikView

add constraint on calculation

Wed, 11 Sep 2013 08:11:50 GMT

Hi,

I have an expression in a chart: Sum(OPCODE_COUNT*SUBSCRIBER_COUNT)

I want to add set analysis that will show the calculation for a specific value of a KEY disregarding users selections.

I wrote this expression : Sum({1<KEY_ID=2>}OPCODE_COUNT*SUBSCRIBER_COUNT)

I get an error sign under the second curly brackets.

what is wrong with the expression?

Thanks,

Wed, 11 Sep 2013 09:10:04 GMT

can you make this one in the script ?

OPCODE_COUNT*SUBSCRIBER_COUNT as total

then try this one

Sum({1<KEY_ID=2>}total)

simondachstr — Wed, 11 Sep 2013 09:10:59 GMT

Try:

Sum({1<KEY_ID={'2'} >}OPCODE_COUNT*SUBSCRIBER_COUNT)

Gysbert_Wassenaar — Wed, 11 Sep 2013 09:15:39 GMT

Close, the value you want to restrict on needs to be in curly braces too:

Sum({1<KEY_ID={2}>}OPCODE_COUNT*SUBSCRIBER_COUNT)