topic Re: Calculated Dimension help in QlikView

Calculated Dimension help

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Calculated Dimension help

vishsaggi — Wed, 19 Apr 2017 15:29:51 GMT

Try like: as your dimension expression?

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

Re: Calculated Dimension help

Wed, 19 Apr 2017 15:58:33 GMT

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.

Re: Calculated Dimension help

vishsaggi — Wed, 19 Apr 2017 16:20:03 GMT

Glad it worked. No problem.