topic chr in QlikView

chr

Thu, 27 Mar 2014 15:53:14 GMT

accountDesc = TA'S AND OTHERS

THIS IS MY SET ANALYSIS

Sum({$<BusinessRegion = {'USA','CANADA','MEXICO','INDIA'},AccountGroup = {'Discounts'},

AccountDesc= { 'TA'&CHR(39)&'S & OTHER'} >}NetSales)

AND ITS NOT WORKING...

THANKS IN ADVANCE

MK_QSL — Thu, 27 Mar 2014 15:57:53 GMT

Sum({$<BusinessRegion = {'USA','CANADA','MEXICO','INDIA'},AccountGroup = {'Discounts'},

AccountDesc= { "TA'S & OTHER"} >}NetSales)

Alternately, if you have

AccountDesc = Other's

You can write as

AccountDesc = {"Other's"}

Aurelien_Martinez — Thu, 27 Mar 2014 15:58:02 GMT

Hi,

Try :

Sum({$<BusinessRegion = {'USA','CANADA','MEXICO','INDIA'},AccountGroup = {'Discounts'},

AccountDesc= {"TA'S & OTHER"} >}NetSales)

Aurélien

Thu, 27 Mar 2014 16:21:00 GMT

what if i want to use this in script .. do i have to use chr?

Aurelien_Martinez — Thu, 27 Mar 2014 16:38:42 GMT

You can not use Set Analyses in the script, but yes you have to use chr

Something like :

LOAD

Field,

Sum(NetSales)

Where AccountDesc='TA'&CHR(39)&'S & OTHER'

;

Thu, 27 Mar 2014 16:59:24 GMT

thanks