Qlik Community

Qlik Sense App Development

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

vikraant
Contributor

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
laddu_927
Valued Contributor

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

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