Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field (Delivered on Time) that reports either "Delivered On Time" or "Delivered Late" I tried to do a few expressions, but Qlik did not accept them, and cannot figure out what I am missing. It tells me I am missing a ")" but I could not tell where.
Count({<[Delivered On Time] = {'Delivered On Time'}>}[Delivered On Time] )
/
Count([Delivered On Time])
Share the expression you have used for a better understanding of your problem.
Thanks for answering. I have been trying constantly. I am now on this expression
Count(distinct [Delivered On Time]) / count([Delivered On Time] = "Delivered On Time")
Basically I need to show the percentage of the amount of times the delivered on time field returns delivered on time.
Count({<[Delivered On Time] = {'Delivered On Time'}>}[Delivered On Time] )
/
Count([Delivered On Time])
Thanks I tried this but the math did not work.
Can you explain why the math didn't work?
Do you have the total count of the 'delivered on time' field and the total count of the 'delivered on time' field is 'delivered on time' to share?
Hey I must have goofed bringing in the expression, it totally works.