Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Shelley
Try like: as your dimension expression?
= IF([JobLine Job Status Code Description] = 'WIP', [JobLine Job Status Code Description])
Try like: as your dimension expression?
= IF([JobLine Job Status Code Description] = 'WIP', [JobLine Job Status Code Description])
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.
Glad it worked. No problem.