Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

concatenation in set analysis

Hi

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



1 Solution

Accepted Solutions
sunny_talwar

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))

View solution in original post

3 Replies
sunny_talwar

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))

Not applicable
Author

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

sunny_talwar

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