topic how to filter on calculated column in Qlik in App Development

how to filter on calculated column in Qlik

vish123 — Mon, 21 Feb 2022 12:30:01 GMT

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.

Re: how to filter on calculated column in Qlik

Or — Mon, 21 Feb 2022 12:35:31 GMT

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)

Re: how to filter on calculated column in Qlik

vish123 — Mon, 21 Feb 2022 12:54:05 GMT

Hi Or,

Thanks for your reply.

Let me see if it works