Text object expression

hkg_qlik — Fri, 29 Jun 2012 15:08:04 GMT

Hi,

I am using the following expression (TEXT OBJECT):

=sum(aggr(count(distinct if( CalendarMonthName= vCurrentMonth and CalendarYear = vCurrentYear,[Message Person ID])),Date))

I want to make it fixed value so it should only show the output for CalendarMonthName= vCurrentMonth and CalendarYear = vCurrentYear and should not get updated even I make any field selections in the application.

Thanks,

Re: Text object expression

Fri, 29 Jun 2012 15:47:55 GMT

You can try this:

=sum(aggr(count(distinct {1<CalendarMonthName= {"$(=vCurrentMonth)"} and CalendarYear = {"$(=vCurrentYear)"}>} [Message Person ID]),Date)

I think aggr function isnt required as your are using in text box. If you have any specific reason ignore this comment.

Regards,

Kiran Rokkam.

topic Text object expression in QlikView

Text object expression

Re: Text object expression