Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

MonthStart(Max(Date)) behaves differently in dollar expansion and normal expression

When I use MonthStart(Max(Date)) as an expression I get expected result

However when I use it in a dollar expansion I get a weird result

I have selected "Date" for number formatting

Any help would be appreciated

Thanks & Best Regards

Vikraant

1 Reply
Highlighted
Specialist
Specialist

How about Try $(=Num(MonthStart(Max(Date))))??