Hello - I am very new to Qlikview and use it as a Business Intelligence tool. I am trying to write a calculated dimension so that it returns only jobs in a WIP status. For Crystal Reports, I could have done this easily, but I'm having trouble grasping how to write it in Qlikview. I don't know what aggregation I need to use to return only a specific value for a field. I thought it was Only, however it's not returning anything but an error so clearly I'm missing something.
Only ([JobLine Job Status Code Description])=WIP
I'm told repeatedly that Qlikview is easier, but it's not easier for me at the moment.
THANK YOU! That worked perfectly. I think I might understand the if statement now. This syntax is completely new to me. I truly appreciate your fast response.
