Sort a column based on external table

[sujit_nath]

I have a feild A with values such as - 

A

Pen

Pencil

Chair

Car

Bike

Now I have received an external file with same columns as :

A	Priority
Pen	2
Pencil	3
Chair	1
Car	5
Bike	4

Now in my Qlikview dashboard, I want to see the data in the order of priority. (PS- I have other data as well apart from those mentioned, but they would follow after these)

My data in dashboard should be like - 

A	Other columns ----
Chair
Pen
Pencil
Bike
Car

[kaushiknsolanki · Accepted solution]

Hi,

Link this data in script with original data.

Once you link them, go to properties of chart -> Sorting -> Find the option to sort by Expression and write the field name of sort. in your case it will be Priority.