topic Re: Text Object (Exp) in QlikView

Text Object (Exp)

hkg_qlik — Wed, 13 Jun 2012 20:33:33 GMT

Hi,

I am trying to use following expression in the text box expression box. But its not working for me.

vCurrentMonth holds the Current Month Info and I want to display the count of the personID when the Create Date Month = vCurrentMonth (i.e June)

=vCurrentMonth & '=' =count({$<[Created Date Month] = {"=vCurrentMonth"}>} DISTINCT [Person ID])

Re: Text Object (Exp)

Wed, 13 Jun 2012 20:38:10 GMT

hi hkghandi

1) you don't need an "=" before the first count expression

2) then another ampersand to concatenate the rest of the string

2) you need a dollar sign expansion in the bit that defines the set. Try:

=vCurrentMonth & '=' & count({$<[Created Date Month] = {$(=vCurrentMonth)}>} DISTINCT [Person ID])

Regards,

Erica

Re: Text Object (Exp)

hkg_qlik — Wed, 13 Jun 2012 21:32:27 GMT

Thanks a lot Erica!