topic Re: RANK and Store in QVD in QlikView

RANK and Store in QVD

didierodayo — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: RANK and Store in QVD

qlikview979 — Wed, 22 Jun 2016 06:54:15 GMT

If you want front end

Dimension:-Store

Expression:-Rank(Sales)

Re: RANK and Store in QVD

tyagishaila — Wed, 22 Jun 2016 06:56:09 GMT

TAB:

LOAD * INLINE [

Store, Sales

A, 3000

B, 2900

C, 756

D, 1645

E, 3680

F, 985

];

TAB1:

LOAD *, RowNo() as Rank

Resident TAB

order by Sales asc;

Store TAB1 into Rank.qvd(qvd);

Drop Table TAB;

Re: RANK and Store in QVD

tyagishaila — Wed, 22 Jun 2016 06:58:37 GMT

For front end,

Add calculated Dimension: Store&Sales

Expression: Store, Sale and Rank(Sum(Sales))

make Store&Sales dimension invisible (Presentation Tab --> Hide Column)

Re: RANK and Store in QVD

qlikview979 — Wed, 22 Jun 2016 07:02:54 GMT

Hi,May be help full

Try this

T1:

load * Inline [

Store, Sales

A, 3000

B, 2900

C, 756

D, 1645

E, 3680

F, 985

];

NoConcatenate

T2:

load *,

RowNo() as rank,

Resident T1 order by Sales desc;

DROP table T1;

Store T2 into ABC.qvd;

Re: RANK and Store in QVD

tamilarasu — Wed, 22 Jun 2016 07:15:18 GMT

Hi Didier,

Try this,

Data:
LOAD * INLINE [
Store, Sales
A, 3000
B, 2900
C, 756
D, 1645
E, 3680
F, 985
G, 985
];

Sales:
LOAD Store,
Sum(Sales) as OverAllSales
Resident Data Group By Store;

NoConcatenate
Rank:
LOAD *,
If(Isnull(Peek('Store')), 1, If(OverAllSales < Peek('OverAllSales'), Peek('Rank')+1, Peek('Rank'))) As Rank
Resident Sales
Order By OverAllSales desc;

Drop Table Sales, Data;

Store Rank into Rank.qvd (qvd);

Note: Script Updated

Re: RANK and Store in QVD

qlikview979 — Wed, 22 Jun 2016 07:33:34 GMT

Hi Bro,

After " F" i am adding "G,985" but Rank is not showing properly why ?

Regards,

Mahesh.

Re: RANK and Store in QVD

Anonymous — Wed, 22 Jun 2016 07:43:13 GMT

Hi mahesh,

Have you tried my code?

It works adding this.

Regards!

Re: RANK and Store in QVD

qlikview979 — Wed, 22 Jun 2016 07:53:02 GMT

Hi Manuel Capella,

This Question was not posted by me. but After " F" i am adding "G,985" Rank is showing same to F&G.

Regards,

Mahesh

Re: RANK and Store in QVD

Anonymous — Wed, 22 Jun 2016 07:55:22 GMT

I know, but I think that it was interesting for you, because you was testing Tamil's answer.

Regards!!

Re: RANK and Store in QVD

tamilarasu — Wed, 22 Jun 2016 07:59:27 GMT

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.

Re: RANK and Store in QVD

didierodayo — Wed, 22 Jun 2016 07:59:46 GMT

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.

Re: RANK and Store in QVD

qlikview979 — Wed, 22 Jun 2016 08:00:04 GMT

Hi Bro,

where can I get Qlikview Sample Dashboards ?

Regards

Re: RANK and Store in QVD

Peter_Cammaert — Wed, 22 Jun 2016 08:00:10 GMT

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

Re: RANK and Store in QVD

Peter_Cammaert — Wed, 22 Jun 2016 08:01:08 GMT

demo.qlikview.com

Re: RANK and Store in QVD

Anonymous — Wed, 22 Jun 2016 08:01:56 GMT

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

Regards!

Re: RANK and Store in QVD

qlikview979 — Wed, 22 Jun 2016 08:03:20 GMT

Hi Bro,

Now Its Working.

where can I get Qlikview Sample Dashboards ?

Regards

Re: RANK and Store in QVD

qlikview979 — Wed, 22 Jun 2016 08:05:27 GMT

Thanks, Bro

Regards

Re: RANK and Store in QVD

Kushal_Chawda — Wed, 22 Jun 2016 08:08:31 GMT

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;

Re: RANK and Store in QVD

tamilarasu — Wed, 22 Jun 2016 08:52:44 GMT

You can also check below path for some sample dashboards.

C:\Program Files\QlikView\Examples\Documents