topic Re: Need help in Expression in QlikView

Need help in Expression

Wed, 05 Sep 2012 08:31:29 GMT

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.

Re: Need help in Expression

whiteline — Wed, 05 Sep 2012 08:42:08 GMT

Closing brackets:

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

Re: Need help in Expression

Wed, 05 Sep 2012 08:52:37 GMT

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.

Re: Need help in Expression

whiteline — Wed, 05 Sep 2012 09:01:58 GMT

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.

Re: Need help in Expression

Wed, 05 Sep 2012 09:14:39 GMT

Dear Whiteline.

Thank you very much.

now very thing is fixed.

Thanks,

Mukram.