Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
Hi Or,
Thanks for your reply.
Let me see if it works