topic Re: Max by State in QlikView

Max by State

coddra_6 — Mon, 23 Dec 2013 22:09:01 GMT

Hey,

I have the next case:

I have the sales of many products by state y I wanna know which product is the best selling by each state. I have the next table:

State Producto Sales

===== ======== ======

New York Cookie 1500

New York Soda 890

California Chocolate 2100

California Candy 2015

California Cookie 2085

And I wanna got the next table:

State Producto Sales

===== ======== ======

New York Cookie 1500

California Chocolate 2100

Hope your help!!

Thanks!!

Re: Max by State

swuehl — Mon, 23 Dec 2013 22:34:16 GMT

Create a chart with dimension State, then two expressions

=FirstSortedValue(Producto, -Sales)

=max(Sales)

Re: Max by State

qlikpahadi07 — Tue, 24 Dec 2013 05:25:03 GMT

May be this help you

Re: Max by State

coddra_6 — Tue, 24 Dec 2013 15:37:36 GMT

Yeah!! This helps!!

And if I wanna make it in the Script Editor??

Re: Max by State

maxgro — Tue, 24 Dec 2013 18:46:30 GMT

you have to change column name, I started from your post http://community.qlik.com/thread/102682

Tab:

LOAD * INLINE [

Departamento, Producto, Ventas

Ica, Galleta, 1500

Ica, Gaseosa, 890

Lima, Chocolate, 2100

Lima, Caramelo, 2015

Lima, Galleta, 2085

];

Tab2:

NoConcatenate load Departamento, Producto, Ventas

where Flag=1;

NoConcatenate load

Departamento, Producto, Ventas, if(Peek(Departamento)<>Departamento or IsNull(Departamento), 1, 0) as Flag

resident Tab

order by Departamento, Ventas desc;

drop table Tab;

Re: Re: Max by State

qlikpahadi07 — Wed, 25 Dec 2013 04:21:23 GMT

here is from Script might be helpful

Merry Christmas !!!!