topic Re: Customized sorting by Calculated Dimension in QlikView

Customized sorting by Calculated Dimension

Fri, 17 Oct 2014 10:07:41 GMT

Hello everyone,

I have created the calculated dimension attribute(like below script) in my pivot table and i want sort the column by ascending exclude 'others ' as i want show the 'others' in the last row.

=if([CAT]='Mobiles & Tablets', 'Mobiles & Tablets',

if([CAT]='Computers & Laptops', 'Computers & Laptops',

if([CAT]='Consumer Electronics', 'Consumer Electronics',

if([CAT]= 'Cameras', 'Cameras',

if([CAT]='Watches', 'Watches',

if([CAT]='Health & Beauty', 'Health & Beauty',

'Others'))))))

Label name is : Category

I tired below script in the sort tab expression but it doesn't work :

WildMatch(Category,'Cameras',Computers & Laptops','Consumer Electronics','Health & Beauty','Mobiles & Tablets','Others')

Match(Category,'Cameras',Computers & Laptops','Consumer Electronics','Health & Beauty','Mobiles & Tablets','Others')

could you please advise me ?

Best,

Robert

Re: Customized sorting by Calculated Dimension

MarcoWedel — Sat, 18 Oct 2014 23:25:12 GMT

Hi,

you could try this sorting expression:

If(

Match([CAT],'Cameras','Computers & Laptops','Consumer Electronics','Health & Beauty','Mobiles & Tablets'),

100)

hope this helps

regards

Marco

Re: Customized sorting by Calculated Dimension

MarcoWedel — Sat, 18 Oct 2014 23:29:11 GMT

Match([CAT],'Mobiles & Tablets','Health & Beauty','Consumer Electronics','Computers & Laptops','Cameras')

in descending order

hope this helps

regards

Marco

Re: Customized sorting by Calculated Dimension

Mon, 20 Oct 2014 02:32:24 GMT

Many Thanks Mr. Marco wedel.

Have a nice day!