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.




      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:



      For GREEN Exp:



      For ALL Exp:



      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.