Text Object (Exp)

[hkg_qlik]

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

[#2 · Accepted solution]

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

[hkg_qlik]

Thanks a lot Erica!