Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.