Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hkg_qlik
Creator III
Creator III

Text object expression

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,

H

1 Reply
Not applicable

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.