# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for
Did you mean:
Creator II

## Why is their a different result in \$ Expansion over a formula

Hi,

Why do I get a different result in a text box when I use dollar expansion over a normal formula

=\$(=DATE(Max({\$}[Master Month Date]),'DD/MM/YYYY'))  Result 0.001335

=DATE(Max({\$}[Master Month Date]),'DD/MM/YYYY') Result 30/11/2016

Why does the expansion produce a number?

1 Solution

Accepted Solutions
MVP

So this isn't working?

[MonthLogged_Open_Balance]={"\$(=Date(Max({\$}[Master Month Date]),'DD/MM/YYYY'))"}

or this may be:

[MonthLogged_Open_Balance]={"=[MonthLogged_Open_Balance] = Max(TOTAL [Master Month Date])"}

5 Replies
MVP

Dollar sign expansion is taking 30/11/2016 as a division rather than a date.

Creator II
Author

How do I bring back a  date ? do I have to use Makedate from Max over year,month and day?

MVP

Why can't you just use this?

=Date(Max({\$}[Master Month Date]),'DD/MM/YYYY')

Where exactly are you using this?

Creator II
Author

I am using inside set analysis

[MonthLogged_Open_Balance]={Date(Max({\$}[Master Month Date]),'DD/MM/YYYY')}

MVP

So this isn't working?

[MonthLogged_Open_Balance]={"\$(=Date(Max({\$}[Master Month Date]),'DD/MM/YYYY'))"}

or this may be:

[MonthLogged_Open_Balance]={"=[MonthLogged_Open_Balance] = Max(TOTAL [Master Month Date])"}