topic Display Max(Amount), Invoice Number, Carrier Name in QlikView

Display Max(Amount), Invoice Number, Carrier Name

Fri, 27 May 2011 07:27:04 GMT

I have attached my requirement, can any one help...

Regards

Joe

Display Max(Amount), Invoice Number, Carrier Name

Fri, 27 May 2011 07:31:57 GMT

Hi,

please can you be more clear on what do you need?

Andrea

Display Max(Amount), Invoice Number, Carrier Name

Fri, 27 May 2011 07:37:07 GMT

Dear Danielato,

I have a dimentions like Amount, Invoice Number, Carrier Name.

Using a Max expression I got the maximum of Amount but I neet to show the the Maximum of Amount to which invoice and Carrier name.

I hope its clear for you..

Thanks

Joe

Display Max(Amount), Invoice Number, Carrier Name

Fri, 27 May 2011 08:22:27 GMT

Hi,
Shouldn't a straight table with dimension Carrier Name and Invoice, and sum(max(Amount)) as expression do the trick?

/@Ungvall

Display Max(Amount), Invoice Number, Carrier Name

Fri, 27 May 2011 08:54:05 GMT

Hi,

I could't understand it, I would like to use this expression in a pivot table.

Thanks in advance

Joe

Display Max(Amount), Invoice Number, Carrier Name

Fri, 27 May 2011 08:59:33 GMT

Hi,
If I understand you correctly - try If(max(Amount) Invoice Number) and If(max(Amount) Carrier Name)...

/@Ungvall

Display Max(Amount), Invoice Number, Carrier Name

Fri, 27 May 2011 09:41:19 GMT

Dear Ungvall,

I have attached my requirements in the orginal post.

Can you solve it.

Thanks in advance.

Joe

Display Max(Amount), Invoice Number, Carrier Name

Fri, 27 May 2011 13:56:06 GMT

Hi vmjoe1978,

Of course what you want is not possible in this case!

The table you make in you load script is not good enough.

You have to load a table like:

Carrier Invoice Amount

A 101 10

B 102 20

B 101 30

C 103 10

A 101 20

C 103 30

B 103 30

C 103 20

A 100 10

Then you can make what you want

Carrie Invoice Total

A 100 10

A 101 30

B 101 30

B 102 20

B 103 30

C 103 60

I hope this helps!

Kind Regards,

Martijn