topic Re: sorting in dimension in QlikView

sorting in dimension

Wed, 06 May 2015 09:58:56 GMT

Hi,

I have a field called 'Main Segment' and i want to use it as a dimension.

like this(=if(Product='bikes', mainsegment)) and the order in mainsegment is:

City

E-Bike

Trekking

and i want them to be like :

E-Bike

City

Trekking any help will be appreciated

Best,

PrashantSangle — Wed, 06 May 2015 10:20:45 GMT

Hi,

In Sort tab-> you can write expression-> in that write

Match(Product,'Your Sort order Product')

Regards

Wed, 06 May 2015 11:57:44 GMT

thanks Max for your reply.

but this is the dimension I have right now: =if(Product='bikes', main segment) where does the 'Your Sort order Product' go?

PrashantSangle — Wed, 06 May 2015 12:03:14 GMT

In Sort tab write below expression

wildmatch(mainSegment,'E-Bike','City','Trekking')

Regards