topic Sorting Issue in QlikView

Sorting Issue

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

Hi All,

can you help me on the below sorting issue.

I have a table with Order & 3 different prices details as below.

the desired output is the prices should sort for each order as shown below.

Looks like simple but not able achieve, can you please help.

MK_QSL — Sat, 07 Apr 2018 08:42:45 GMT

How to source data ?

Can you provide source data ?

Anonymous — Sat, 07 Apr 2018 08:51:21 GMT

Please find the sample data. Source is excel files with static prices per order, there won't be any change once we receive the data.

MK_QSL — Sat, 07 Apr 2018 09:04:07 GMT

Use below in script

CrossTable(Price,Value)

Data:

LOAD Order,

[Price1($)],

[Price2($)],

[Price3($)]

FROM

Community_297434.xlsx

(ooxml, embedded labels, table is Input);

Now use

Dimension

Order

Expressions

Max(Value,3)

Max(Value,2)

Max(Value,1)

Anonymous — Sat, 07 Apr 2018 09:09:13 GMT

Thanks !!

It's working