RANK and Store in QVD

[didierodayo]

Hello,

I would like to rank the following table where the highest sale is ranked 1. then I ill store the table into qvd with a new field Ranking.

Store	Sales
A	3000
B	2900
C	756
D	1645
E	3680
F	985

Thanks You.

[tamilarasu]

Mahesh,

Thanks for pointing out. I have not tested the above code. Now, I have updated the script. Could you check and update here, please.

[didierodayo]

Thanks you all for your replies, I really appreciate the effort. I am going to try the different options and mark the suitable one off.

[qlikview979]

Hi Bro,

where  can I get Qlikview Sample Dashboards ?

Regards

[Peter_Cammaert]

Isn't that the idea? That identical values get the same ranking? And the next rank will be skipped?

[Peter_Cammaert]

demo.qlikview.com

[Anonymous]

HI mahesh, you can find some free demos on http://us-b.demo.qlik.com/

Regards!

[qlikview979]

Hi Bro,

Now Its Working.

where  can I get Qlikview Sample Dashboards ?

Regards

[qlikview979]

Hi

Thanks, Bro

Regards

[Kushal_Chawda]

Data:

LOAD *

FROM Table;

New:

noconcatenate

load Store,

        Sum(Sales) as Store_Sales

Resident Data

group by Store;

Rank:

LOAD *,

          autonumber(Store_Sales) as Rank

Resident New

order by Store_Sales desc;

drop table New;

[tamilarasu]

You can also check below path for some sample dashboards.

C:\Program Files\QlikView\Examples\Documents