topic Difference Count between current and previous status in QlikView

Difference Count between current and previous status

rfigueroa — Fri, 23 Mar 2012 19:27:24 GMT

Hi,

In the example attached I need a second expression to get the difference between the COUNT of GrupoLink in current status and the COUNT for previous status.

For example for "DTU" status there is a count of 93, so I need a stacked second bar with the difference with "Terminada" status count which is 116.

As a demo I have added a third expression (green) with hardcoded values to show you the goal.

In the script I added a Prev_Estatus field, to point out to the previous status to try something like:

COUNT( {$ <Estatus = {$(=Prev_Estatus)} > } GrupoLink)

but didn't work

Thanks in advance for your help.

Roberto.

Re: Difference Count between current and previous status

Jason_Michaelides — Fri, 23 Mar 2012 19:59:21 GMT

Your first expression is =COUNT(DISTINCT GrupoLink)

Your second expression should be =Above(COUNT(DISTINCT GrupoLink)) - COUNT(DISTINCT GrupoLink)

See attached.

Hope this helps,

Jason

Message was edited by: Jason Michaelides - file attached!

Difference Count between current and previous status

rfigueroa — Fri, 23 Mar 2012 21:27:02 GMT

So simple
Thank you.