topic Re: Need a help in set analysis in QlikView

Need a help in set analysis

Sat, 01 Sep 2012 11:54:15 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) when ReceptaclesTransactions.ProcedureID=1 and Count(Dispatches.DispatchID)<>0

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

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

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

i tried by using if condition but it's not working fine.

and i also tried by creating a variable vCount_DispatchID=count(Dispatches.DispatchID)

like in set anlaysis for 1 expression

=Count({<ReceptaclesTransactions.ProcedureID={1} , vCount_DispatchID-={0} >} Flights.FlightID)

so please help me out to solve the issue.

Thanks,

Mukram.

Re: Need a help in set analysis

Sat, 01 Sep 2012 12:16:00 GMT

what do you use a set analysis? Why do you calculate from script four expression whit a group by? if you calcoleted from script le performance is best than calculated from tab .

Re: Need a help in set analysis

sebastiandperei — Sat, 01 Sep 2012 14:34:03 GMT

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

2) Count({<ReceptaclesTransactions.ProcedureID={"1"}>} Flights.FlightID)

3) Count( Flights.FlightID )

If You want to use "full" Set Analysis expression, you could try this:

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

Re: Need a help in set analysis

Tue, 04 Sep 2012 21:38:20 GMT

Dear Sebastian Pereira

Thanks for your reply.

i tried your solution but it's not working.

this is some part of the my data model. which i am using in the following scenario.

so i need a barchart which show four bars as i discussed in previous reply..

Like RED ,BLACK ,GREEN and ALL.

if any body need any more details then let me know.

so please some one help me out.

Thanks,

Mukram

Re: Need a help in set analysis

sebastiandperei — Wed, 05 Sep 2012 02:23:27 GMT

Hi Mukam,

Could you please send a copy? reduced at least...

Re: Need a help in set analysis

Wed, 05 Sep 2012 06:27:18 GMT

Dear,

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.

Re: Need a help in set analysis

Wed, 05 Sep 2012 06:57:27 GMT

Dear Community.

kindly somebody help me to solve the above Issue.

Thanks,

Mukram.