Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
pradeepm
Contributor II
Contributor II

Sorting Issue

Hi All,

can you help me on the below sorting issue.

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

 

OrderPrice1($)Price2($)Price3($)
A321
B243
C867

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

 

OrderPrice1($)Price2($)Price3($)
A123
B234
C678

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

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

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)

View solution in original post

4 Replies
MK_QSL
MVP
MVP

How to source data ?

Can you provide source data ?

pradeepm
Contributor II
Contributor II
Author

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
MVP
MVP

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)

View solution in original post

pradeepm
Contributor II
Contributor II
Author

Thanks !!

It's working