Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
criscoutinho02
New Contributor II

Using Calculated expression as a filter in Set Analysis

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 .

2 Replies

Re: Using Calculated expression as a filter in Set Analysis

Have you tried this?

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


Capture.PNG

criscoutinho02
New Contributor II

Re: Using Calculated expression as a filter in Set Analysis

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

This solved my problem .

Community Browser