how to filter on calculated column in Qlik

[vish123]

Hi Team,

I have created a segmentation of one field in Qlik app in the front end as below based on its value as below.

if(sales>100, high, if(sales<50 ,Medium, low)). I know as this is a calculated column and cannot be filtered if we use in frond end. Also know it can be created in back end so it can be filtered. But i just wanna check is there any other way to find a alternative solution. Please suggest if any.

[Or]

You can create this as a calculated dimension and filter on it that way. For example, if your table's dimensions are Customer and Item, your additional dimension would be =Aggr(Sum(sales),Customer,Item)

[vish123]

Hi Or,

Thanks for your reply.

Let me see if it works