Sort a column based on external table

sujit_nath — Sat, 16 Nov 2024 01:18:15 GMT

I have a feild A with values such as -

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

Re: Sort a column based on external table

kaushiknsolanki — Wed, 12 Feb 2020 17:12:36 GMT

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.

topic Re: Sort a column based on external table in QlikView

Sort a column based on external table

Re: Sort a column based on external table