topic Re: Sort by field value in QlikView

Sort by field value

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

Hy guys , is there any way to sort one field by the value of other field?

I tried something like this , but it didn`t work:

if(LEVEL1='Clothes',match(LEVEL2,'Hat','T-shirt','Shirt'),

if(LEVEL1='Electronics',match(LEVEL2,'Laptop','Phone','SmartWatch')))

So the order should be

Clothes

-hat

-t-shirt

-shirt

Electronics

-laptop

-phone

-smartwath

Thank you.

jonathandienst — Wed, 28 Sep 2016 07:47:29 GMT

"It didn't work" does not describe the problem. So I am guessing here

if(LEVEL1='Clothes',match(LEVEL2,'Hat','T-shirt','Shirt'),

if(LEVEL1='Electronics', match(LEVEL2,'Laptop','Phone','SmartWatch')+3))

Anil_Babu_Samineni — Wed, 28 Sep 2016 07:54:19 GMT

Instead of that, You can try this too

If(Pick(LEVEL1='Clothes',match(LEVEL2,'Hat','T-shirt','Shirt')),

if(Pick(LEVEL1='Electronics',match(LEVEL2,'Laptop','Phone','SmartWatch'))))

razvan_brais — Wed, 28 Sep 2016 08:04:50 GMT

"It didn`t work" means that it doesn`t order after my expression. What I expect to see is the order from above ,

but what I see is this :

Clothes

-t-shirt

-shirt

-hat

Electronics

-smartwath

-phone

-laptop

Anil_Babu_Samineni — Wed, 28 Sep 2016 08:26:11 GMT

What expression you wrote?

razvan_brais — Wed, 28 Sep 2016 08:27:31 GMT

Both of them and still doesn`t work. When I`m writing your expression it gives me error in expression at the last ')'.