4 Replies Latest reply: Sep 13, 2011 11:08 AM by Sunil Chauhan RSS

    problems with a gauge chart

    Aissam Boumejjane

      Hi Guys,

       

      I have a gauge chart that calculates the performance of shipments ontime. This is the expression that I use:

       

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

       

      snapshot.JPG

      The results are oke as long as I don't select the late shipments in the one of the selection fields.

      When I select shipments that are Late, the performance meter goes over 1000% :S, which is complete wrong.

       

      Is my expression set right? or do I need to add something else to my expression? or is the problem somewere else.

       

      I've attached my qlikview.

       

      Hope u can help me out!!

       

      Thanks in advance

       

      iSam