Need help in Expression

[#1]

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.

[whiteline]

Closing brackets:

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

[#3]

Dear,

Thanks for your help three bar expressions are working.

How to write the Expression for Black Exp:

i wrote like this but it's not working

=If(Count(Dispatches.DispatchID)=0,count(Flights.FlightID))

=count(If(Count(Dispatches.DispatchID)=0,Flights.FlightID))

Thanks,

Mukram.

[whiteline · Accepted solution]

Maybe:

=Count(aggr(If(Count(Dispatches.DispatchID)=0,Flights.FlightID), Flights.FlightID))

I think, you should use aggr explicitly as you use fields from differnet tables.

[#5]

Dear Whiteline.

Thank you very much.

now very thing is fixed.

Thanks,

Mukram.