topic Re: table with max value in QlikView

table with max value

Mon, 26 Nov 2012 09:24:16 GMT

Hi all,

I need help. I have this table:

ID	Sub ID	Price
1	111	1,8
	112	1,4
	113	2,3
2	222	1,7
	223	3,4
	224	1,2

And I want to create a table that visualize only the Sub ID with the max price. Eg:

ID	Sub ID	Price
1	113	2,3
2	223	3,4

How can I obtain this table?

Thanks all.

Re: table with max value

its_anandrjs — Mon, 26 Nov 2012 09:27:56 GMT

Hi,

Use Max(Price) to obtain this

Regards,

Anand

Re: table with max value

its_anandrjs — Mon, 26 Nov 2012 09:34:06 GMT

Hi,

Dimension use ID

Expression Max(Price)

HTH

Regards,

Anand

Re: table with max value

Mon, 26 Nov 2012 09:56:40 GMT

If I use max Price i obtain the first table, because it give me for each Sub Id the max price. Instead, I want obtain only the sub id with the max price for each ID.