topic concatenation in set analysis in QlikView

concatenation in set analysis

Mon, 06 Feb 2017 15:51:41 GMT

I have a calculation, as below - which is failing:

=if (

sum( < NPSYear &' '& NPSQuarter = {'2016 Q3'} >} [Score])

<11 , argb(150, 255,0,0), argb(150, 0,128,0) )

I assume it is the ampersand ?

I have tried putting NPSYear &' '& NPSQuarter into a variable - vQtr, and using it here, but no luck. Any ideas!

Cheers

Andrew

sunny_talwar — Mon, 06 Feb 2017 15:56:23 GMT

Left hand side of a set modifier cannot be a function or calculation.... try like this may be?

=If(Sum(<NPSYear = {2016}, NPSQuarter = {'Q3'}>} [Score]) <11, ARGB(150, 255,0,0), ARGB(150, 0,128,0))

Mon, 06 Feb 2017 15:58:39 GMT

it can't? Well that's good information! Many thanks

sunny_talwar — Mon, 06 Feb 2017 15:59:33 GMT

Yes, left hand side needs to be a field which is derived in the script. No calculations or functions are allowed on the left hand side