Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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)