Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
tinkerz1
Creator II
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
sunny_talwar

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])"}

View solution in original post

5 Replies
sunny_talwar

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

tinkerz1
Creator II
Creator II
Author

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

sunny_talwar

Why can't you just use this?

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

Where exactly are you using this?

tinkerz1
Creator II
Creator II
Author

I am using inside set analysis

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

sunny_talwar

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])"}