How to sort dimension by expression and remove som... - Qlik Community

vanand3535 · ‎2018-03-07

Dimension----Category

Measure----Sum(Sales)

First of all I have tried to sort the dimension values that I have done successfully by expression:-

If(CategoryName='Men´s Footwear',1,

if(CategoryName='Babywear',2,

if(CategoryName='Children´s wear',3,

if(CategoryName='Ladies´Footwear',4,

if(CategoryName='Bath Clothes',5,

if(CategoryName='Sportwear',6,

if(CategoryName='Womens wear',7,

if(CategoryName='Men´s Clothes',8

))))))))

Now I want to remove some of the values from the dimension lik:-

Babywear, Men's Clothes, Sportwear

So, How can I do this?

Anonymous · ‎2018-03-07

Hi Vivek,

You can use set expression in your measure to exclude values you're not interested in.

Check out:

isingh30 · ‎2018-03-07

You want to remove them (permanently) or hide them & change the order?

vanand3535 · ‎2018-03-07

just wanna hide two-three values from dimension

tell me both how to hide and delete values from dimension after sorting

because sorting i have already done successfully

isingh30 · ‎2018-03-07

You can hide by putting // in front of if statement & for the rest you can change the order.

isingh30 · ‎2018-03-07

You can remove if statement from the script as well but it's not a dynamic solution. I believe your data will change in future. Agreed?

vanand3535 · ‎2018-03-07

Just now I tried

In Measure I tried the syntax:-

Sum({<CategoryName -={'Babywear','Sportwear','Ladies´Footwear'}>}Sales)

it's working well.

is this correct or not?

vanand3535 · ‎2018-03-07