4 Replies Latest reply: Sep 5, 2012 5:14 AM by qva_mukram RSS

    Need help in Expression

      Dear All.

      i want to create a bar chart which shows 4 bars without dimension.

      four bars as follows Green , Red ,Black ,Yellow.

       

      expressions:

       

      1) expression for Green Bar----> count(Flights.FlightID) where ReceptaclesTransactions.ProcedureID=1 and Count(Dispatches.DispatchID)<>0

       

      2) expression for Red Bar----> count(Flights.FlightID) where ReceptaclesTransactions.ProcedureID<>1 and Count(Dispatches.DispatchID)<>0

       

      3) expression for Black Bar----> count(Flights.FlightID) where Count(Dispatches.DispatchID)<>0

       

      4) expression for Yellow Bar----> count(Flights.FlightID).

       

       

      Bar chart :

      i tired the following expression but it's not giving proper solution

       

      1)For RED Bar Expression:

       

      =Count({<ReceptacleTransactions.ProcedureID -={"1"}, Flights.FlightID={"=Count(Dispatches.DispatchID<>0"}>}Flights.FlightID)

       

      For Black:

        =count(If(vCount_DisptachID=0,(Flights.FlightID)))

       

      For GREEN Exp:

      =Count({<ReceptacleTransactions.ProcedureID={"1"},Flights.FlightID={"=Count(Dispatches.DispatchID<>0"}>}Flights.FlightID)

       

      For ALL Exp:

      =count(Flights.FlightID)

       

      so some one please help me to fix the issue.

       

      Kindly find the attachment of qvw file.

       

       

       

      so please help me out to solve the issue.

       

      Thanks,

      Mukram.