Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

apply set analysis on a variable

my variable is a formula like this:

v1= (sum(a)+sum(b))/sum(c)

when i use it in a table i want to apply a set analysis to the variable to exclude a particular selection to obtain this result.

(sum{$<cod = >}(a) + sum{$<cod = >}(b)) / sum{$<cod = >}(c)

is it possible?

thanks



1 Reply
Miguel_Angel_Baeyens

Hello,

If you have your variable so defined already, it's not possible to change it on a table. But you can create a new variable with those set analyses and specify which one to use in the chart.

Hope that helps