Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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