topic Re: Text Object in QlikView

Text Object

hkg_qlik — Thu, 25 Oct 2012 16:16:53 GMT

Hi,

I am trying to get no of customer information for current month in a text object.

Variable for current month: vThisMonth

I am trying something like this, but its not working.

=count({1<Month = {="vThisMonth"}> Cust.Counter)

Thanks,

MayilVahanan — Thu, 25 Oct 2012 16:21:00 GMT

Try like this

=count({1<Month = {'$(=vThisMonth)'}> Cust.Counter)

Hope it helps

hkg_qlik — Thu, 25 Oct 2012 16:25:20 GMT

I tried it. Not working.

MayilVahanan — Thu, 25 Oct 2012 17:11:17 GMT

Check the attached file..

Hope it helps

CELAMBARASAN — Thu, 25 Oct 2012 17:22:58 GMT

Make sure that Month field and the value stored in the Variable vThisMonth are in same format.