topic apply set analysis on a variable in QlikView

apply set analysis on a variable

Fri, 22 Oct 2010 09:23:56 GMT

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

apply set analysis on a variable

Miguel_Angel_Baeyens — Fri, 22 Oct 2010 09:35:29 GMT

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