Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculated Dimension help

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

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

Try like: as your dimension expression?

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

View solution in original post

3 Replies
vishsaggi
Champion III
Champion III

Try like: as your dimension expression?

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

Not applicable
Author

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
Champion III
Champion III

Glad it worked. No problem.