Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
dandaanilreddy
Not applicable

Replace function in qliksense

Hello Qlik Developers

I am using a piviot table in qlik sense in measures i wrote an expression which calculates the max 8 week in the label i wrote =Replace(vMax8Week,'"','') expression but its not giving the max 8 week date but in qlikview its showing the date. Can some one help me how to get the date. Please find the attached image below i want to display the date for all the expressions;

Expression: count({<Master_WeekStart={$(vMax8Week)}>} Kit_ID)

Label: =Replace(vMax8Week,'"','')

2 Replies
sunny_talwar
Not applicable

Re: Replace function in qliksense

I think Qlik Sense doesn't allow for a calculated expression label.

dandaanilreddy
Not applicable

Re: Replace function in qliksense

Hi Sunny

Thanks for your reply is there any way we can display the dates in the pivot table for the expressions as mentioned in the image?

Thanks

Anil