Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have the following problem in QlikView:
- I created a conditional dimension in an object, which is based on three conditions of other dimensions, what works properly with a simple if(and, and, and) function.
- to finalize my intention, I thougt I need to include another condition on top to the three existing conditions. This last condition is based on an expression which is already included in the same object as a column. This expression has values, but I just want to display the values above X (>=X). If I include the condition as a fourth condition in the if() function, I get an calculation error.
At the moment, I export the object and remove manually the the values below my threshold X. This is what I want to avoid in my final step.
Should I create another separate if() function on top to my existing one in the conditional dimension and combine them with "and", which has a condition on my expresssion to be above the threshold? Or is there any possibility to set a condition on the whole object just to display value of the expression above the threshold?
Thanks a lot for your help!
BR, Bodo
Generally speaking, you can't directly use a measure in a dimension. Measures are calculated per set of dimension members, meaning they can't be calculated until the dimensions are known (otherwise, you'd get into a loop - recalculate dimension, then recalculate measure, ad infinitum).
If you need a dimension that is based on a calculation, you'd typically need to use aggr() to calculate it in a predetermined way.