topic Re: Get Max Date selling rate Using set analysis in QlikView

Get Max Date selling rate Using set analysis

muniyandi — Mon, 10 Sep 2012 07:33:11 GMT

Hi.

How to get Max Date selling rate Using set analysis.partwise ,itemwise.

I select Year or Month

Not Working:

My Expression:

ONLY({<YEAR=,Month=,SalesDate={"=((Aggr(NoDistinct Max(SalesDate),PARTYID,Item)))"}>} Rate)

My sample file attached.Pls hlep.

Regards,

Muni

whiteline — Mon, 10 Sep 2012 07:58:57 GMT

=ONLY({<YEAR=,Month=,SalesDate={"=SalesDate=Max(total SalesDate)"}>} Rate)

muniyandi — Mon, 10 Sep 2012 08:06:14 GMT

Thanks for your reply.

i need partywise ,itemwise Maxdate in selling rate

this expression not working.

whiteline — Mon, 10 Sep 2012 08:25:12 GMT

Don't understand you.

Could you explain a bit more in terms of your fields and data ?

muniyandi — Mon, 10 Sep 2012 08:56:39 GMT

Report Sales :

1. sales items are different rate for different party.

2. now i select year or Month, Dimentions -->PARTYID,ITEMID ,(max of date) rate

EX : PARTYID, ITEMID,DOCDATE ,RATE

A , AA ,01/APR/2012 ,80

B , AA ,03/APR/2012 ,85

A , BB ,10/JUN/2012 ,140

B , AA ,15/JUN/2012 ,100

A , AA ,18/JUN/2012 ,105

i select year=2012 only result will be need.

PARTYID,ITEMID, RATE

A ,AA , 105 (Based on max of docdate rate)

A ,BB , 85

B ,AA , 100

whiteline — Mon, 10 Sep 2012 09:13:01 GMT

Just remove total qualifier:

=ONLY({<YEAR=,Month=,SalesDate={"=SalesDate=Max(total SalesDate)"}>} Rate)