topic Re: How to add column to existing expression? in QlikView

How to add column to existing expression?

Mon, 16 Mar 2015 15:47:54 GMT

Hi,

I have below expression in chart

=COUNT({<[Status] -= {'SalesCounter','Ground'}>}DISTINCT CustomerID)

I need to add one more column Region to above expression.

The region have blanks and 3,4. But I need to add only Region =3,4.

How to add the Region to the existing expression? Can anyone suggest me.

Thanks.

MK_QSL — Mon, 16 Mar 2015 15:56:20 GMT

=COUNT({<[Status] -= {'SalesCounter','Ground'}, Region = {'3','4'}>}DISTINCT CustomerID)

Mon, 16 Mar 2015 15:58:13 GMT

Thanks. how to change the same expression if I need to show all integers in Region except blanks?

awhitfield — Mon, 16 Mar 2015 15:59:25 GMT

=COUNT({<[Status] -= {'SalesCounter','Ground'}, Region = {'*'}>}DISTINCT CustomerID)

MK_QSL — Mon, 16 Mar 2015 16:03:45 GMT

Region = {'*'}

or Create below in your script

IF(IsNull(Region) or Len(Trim(Region))=0, 0, 1) as RegionNotNullFlag

Now instead of Region = something......use

RegionNotNullFlag= {'1'}