topic Using Calculated expression as a filter in Set Analysis in QlikView

Using Calculated expression as a filter in Set Analysis

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

Hello All.

I am struggling in a problem with a slider and a variable.

I have to filter the data in the table based on a variable , it's working fine , but the user can hide\show the columns that I use to calculate this variable, when the columns are hided I only get wrong results or error.

I tried to use Aggr and Set Analysis , but I couldn't make it work out.

Has anyone seen anything like that? I attached the example.

Thank you very much .

Re: Using Calculated expression as a filter in Set Analysis

sunny_talwar — Tue, 20 Sep 2016 00:37:52 GMT

Have you tried this?

=Sum(Aggr(If($(v_Range),$(v_Milleage_Change),0), CODE_PRODUCT, GROUP, MILLEAGE, NUM_VEHICLE, MILLEAGE_CHANGE))

Re: Using Calculated expression as a filter in Set Analysis

Anonymous — Tue, 20 Sep 2016 18:42:30 GMT

Hi Sunny , thank you very much . I guess I wasn't aggregating all dimensions needed.

This solved my problem .