'advanced' expression in a Gauge Chart

[Anonymous]

Hi Guys,

I'm still a newbie so forgive me for my ignorance.

I used to have a expression for my gauge chart that would calculate the performance of shipments ontime:

gauge expression:

Count({<Status={OnTime}>} Destination) / Count ( {<Status= >} Destination)

Since my data got a bit complex I had to remove the field "Status". Instead I would use an calculated dimension to see how many shipments are ontime or late.

This would be my chart expression.

=if(NetWorkDays(DEP,POD)<='LimitDays', 'OnTime', 'Late')

This works fine on a bar chart as it shows me ontime and late shipments.

I now want to messure the preformance, so I was wondering how can I translate the above gauge expression, without having a the status field?

The expression should be something like this

Count(Distinct Shipmentnumber that are ontime and divide them by all the shipments (ontime and late)

Dont know how to translate that to qlikview language :S

Thanks in advance

iSam

[Anonymous]

Hi Dennis,

Thanks for your response. I’ve attached my file.

Cheers!

iSam

[#3]

Try this expression:

sum(if(NetWorkDays(DEP,POD)<=LimitDays,1,0))/ Count(DEP)

Also, change the min on the gauge to 0, the result in the sample you gave returns 29% which will not show properly since your gauge is limited to 90-100 percent

[Anonymous]

Can it be around 30%?

See attached file.

I used marcsliving 's expression.

Succes.

Dennis.

[Anonymous]

Thanks Dennis!! ‘t werkt!

[Anonymous]

Hi Marc,

THANKS MAN! IT worked. yeey J I am also curious,

sum(if(NetWorkDays(DEP,POD)<=LimitDays,1,0)) <ß doesn’t it sum all the shipments that are ontime?

Cheers!

iSam

[#7]

Yes it is summing all the shipments that are on time. It should be the same as if you are counting only the ontime shipments.

I have used this method several times when I want to count a field based on certian criteria.