Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
jsobrinho
Creator
Creator

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

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? 

Labels (2)
1 Solution

Accepted Solutions
jsobrinho
Creator
Creator
Author

First of all, thank you for answer..

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

Thank you.

View solution in original post

3 Replies
Lisa_P
Employee
Employee

Can you give more information please ?

jsobrinho
Creator
Creator
Author

First of all, thank you for answer..

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

Thank you.

gchavez
Partner - Contributor
Partner - Contributor

hi! How did you solve it?