Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

If expressions results in "invalid dimension' - any hints?

=If((Sum({<[Win/Lost] ={Won}>}[Estimated Oi UnWeighted]))/((Sum({<[Win/Lost] ={Won}>}[Estimated Oi UnWeighted])+Sum({<[Win/Lost] ={Lost}>}[Estimated Oi UnWeighted])+Sum({<[Win/Lost] ={Cancel}>}[Estimated Oi UnWeighted])))<=1.0 and (Sum({<[Win/Lost] ={Won}>}[Estimated Oi UnWeighted]))/((Sum({<[Win/Lost] ={Won}>}[Estimated Oi UnWeighted])+Sum({<[Win/Lost] ={Lost}>}[Estimated Oi UnWeighted])+Sum({<[Win/Lost] ={Cancel}>}[Estimated Oi UnWeighted])))>=0.5,'H',

If((Sum({<[Win/Lost] ={Won}>}[Estimated Oi UnWeighted]))/((Sum({<[Win/Lost] ={Won}>}[Estimated Oi UnWeighted])+Sum({<[Win/Lost] ={Lost}>}[Estimated Oi UnWeighted])+Sum({<[Win/Lost] ={Cancel}>}[Estimated Oi UnWeighted])))<0.5 and (Sum({<[Win/Lost] ={Won}>}[Estimated Oi UnWeighted]))/((Sum({<[Win/Lost] ={Won}>}[Estimated Oi UnWeighted])+Sum({<[Win/Lost] ={Lost}>}[Estimated Oi UnWeighted])+Sum({<[Win/Lost] ={Cancel}>}[Estimated Oi UnWeighted])))>=0.25,'M',

If((Sum({<[Win/Lost] ={Won}>}[Estimated Oi UnWeighted]))/((Sum({<[Win/Lost] ={Won}>}[Estimated Oi UnWeighted])+Sum({<[Win/Lost] ={Lost}>}[Estimated Oi UnWeighted])+Sum({<[Win/Lost] ={Cancel}>}[Estimated Oi UnWeighted])))<0.25 and (Sum({<[Win/Lost] ={Won}>}[Estimated Oi UnWeighted]))/((Sum({<[Win/Lost] ={Won}>}[Estimated Oi UnWeighted])+Sum({<[Win/Lost] ={Lost}>}[Estimated Oi UnWeighted])+Sum({<[Win/Lost] ={Cancel}>}[Estimated Oi UnWeighted])))>=0,'L',

'0')))

1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

If this answerd your question please mark it as answered and/or helpful. If it wasn't answered fully please ask more...

View solution in original post

3 Replies
petter
Partner - Champion III
Partner - Champion III

A dimension has to created based on or including one of these to become valid:

  • Field
  • ValueList()
  • ValueLoop
  • Aggr()

Your expression has/is neither of these. A dimension will also be calculated before any rows are produced based on all the dimensions in a chart - which if you think of it would be natural.

The Aggr() function is most likely what you would need to use in your case. Something like this could be a template for  you to explore:

=Aggr(

    <Your complicated expression above> , <Dim1>, <Dim2>....

)



The <Dim1>, <Dim2> .... would be the other dimensions that your are using in your chart.

Anonymous
Not applicable
Author

Great help. I always missed to include the dimension in my prior trials. Thanks a lot!!

petter
Partner - Champion III
Partner - Champion III

If this answerd your question please mark it as answered and/or helpful. If it wasn't answered fully please ask more...