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

Calculated dimension - value null

When "Valore" is null, this expression is not valid.
= aggr(sum(If(Um = 'EU' , [Valore]))/sum(If(Um = 'LT' , [Valore])), Mese)
so it return "-" but all calculated dimensions that follow it are not showed.......
When I move back this dimension, I can see the others
What I can do?
thank's for your help!
1 Solution

Accepted Solutions
Not applicable
Author

I have solved this problem using condition If....

= If(Um = 'EU'  and [Valore] >=0, aggr(sum(If(Um = 'EU' , [Valore]))/sum(If(Um = 'LT' , [Valore])), Mese), 0)

View solution in original post

3 Replies
ToniKautto
Employee
Employee

Please post a sample QVW so that your solution can be evaluated.

Not applicable
Author

of course!  the dimension is "PROBLEM"

Not applicable
Author

I have solved this problem using condition If....

= If(Um = 'EU'  and [Valore] >=0, aggr(sum(If(Um = 'EU' , [Valore]))/sum(If(Um = 'LT' , [Valore])), Mese), 0)