Calculated Dimension help

[#1]

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

[vishsaggi · Accepted solution]

Try like: as your dimension expression?

= IF([JobLine Job Status Code Description] = 'WIP', [JobLine Job Status Code Description])

[#3]

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.

[vishsaggi]

Glad it worked. No problem.