A problem with max of a field function

[#1]

Hi, guys!

Please help me find a solution. I have a problem here.\

This is my table:

Employee	DataAccount	DateAccount
Pavel Kovalski	1,00	Nov 2014
Pavel Kovalski	1,00	Dec 2014
Pavel Kovalski	1,00	Jan 2015
Pavel Kovalski	1,00	Feb 2015
Kirill Abramov	0,00	Mar 2014
Kirill Abramov	0,00	Oct 2014
Kirill Abramov	0,00	Nov 2014
Kirill Abramov	0,05	Jan 2015
Kirill Abramov	0,14	Sep 2014
Kirill Abramov	0,23	Sep 2014
Kirill Abramov	0,64	Sep 2014
Kirill Abramov	0,95	Jan 2015
Kirill Abramov	1,00	Feb 2014

I need to find Max value of DataAccount for each month.

I try like :

Load Employee, DateAccount ,

Max(DataAccount) as Values

Resident Table2

Group By Employee, DateAccount ;

But it doesnt work, it gives me  this :" - " for each eriod . I also tried like Num#(Max(DataAccount)) or Num(Max(DataAccount)), but again no result.

[#2]

Martin,

yes, it is left aligned. I tried to use your formula but it gives me only 0 as numbers

[#3]

Also the strange thing is that I made a listbox of DataAccount and it showed me this:

0
-0,01
-0,02
-0,03
-0,04
-0,05
-0,06
0,01
0,02
0,03
0,04
0,05
0,06

For each positive number there is a negative. Why does Qlikview load my values like this? I dont have any negative numbers in my Excel file...

[martinpohl · Accepted solution]

Hi Diana,

where are your datas from?

have you tried num#(DataAccount,'#,##')  ?

As I can see all datas are between 0,05 and 1, so maybe they are percentage values.

If I can't script the script edit to get calculateable values use a trick:

change the values to percentage

0,05 = 5

0,65 = 65

1,00 = 100

so that there are no commas.

load the datas and then recalculate them by devide them by 100

load DataAccount/100 as DataAccount

For this value you can calculate the max.

Regards

[#5]

Martin,

It worked perfectly well! Great. Thank You!