topic Set analysis not working (Set analysis column 1 change value to Set analysis column 2) in QlikView

Set analysis not working (Set analysis column 1 change value to Set analysis column 2)

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

Hi guys,

I have a set analysis expression where I do calculate by a period divided by a period to last year, I have the alternate state too.

When I try to calculate

expression 1 / expression 2

its like qlikview ignore the expression 1 (keeping the expression 1 = 0) and show values to expression 2, but if I separate in different columns and I disable the expression 1, the expression 2 has values, and if I disable the expression 2, the expression 1 has values but I can't keep the two expressions enables, because I have the expression 1 = 0

Its possible one expression change values in another expression?

Re: Set analysis not working (Set analysis column 1 change value to Set analysis column 2)

Lisa_P — Mon, 09 Mar 2020 00:10:11 GMT

Can you give more information please ?

Re: Set analysis not working (Set analysis column 1 change value to Set analysis column 2)

jsobrinho — Mon, 09 Mar 2020 09:27:18 GMT

First of all, thank you for answer..

The problem was solved using the rangesum, above, e aggregate

Thank you.

Re: Set analysis not working (Set analysis column 1 change value to Set analysis column 2)

gchavez — Mon, 20 Sep 2021 16:21:05 GMT

hi! How did you solve it?