Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

p_gerbaux
New Contributor II

sum into a table (without depending dimension)

Hi Everybody.

I don't find a solution to my problem. But i know that you're present with a solution.

And so I say you : thanks 😉

My problem is the next one :

My data source is :

VehicleDate_of_ControlDefect_onCity_of_verification
A

11/02/2014

MotorNY
A11/02/2014BrakeNY
A11/02/2014LightNY
B11/02/2014NY
C13/03/2014MotorBoston
C13/03/2014BrakeBoston
D10/09/2013WheelNY

E

01/06/2013Boston
F24/05/2014BrakeBoston
G26/05/2014Boston

And the result must be :

CityDefect_onQty_defect_Y2013Qty_defect_Y2014Qty_vehicle_verified_Y2013Qty_vehicle_verified_Y2014Col3/Col5Col4/Col6
NYMotor

0

112

0

0.5
NYBrake011200.5
NYLight011200.5
NYWheel101210
BostonMotor011300.33
BostonBrake021300
BostonLight001300
BostonWheel001300

Thanks.

1 Solution

Accepted Solutions
jsaradhi
Valued Contributor

Re: sum into a table (without depending dimension)

for Qty_vehicle_verified_Y2013, use the following expression

count(DISTINCT total <City_of_verification> {<Date_of_Control={'>01/01/2013<=31/12/2013'}, Defect_on=>}Vehicle)

for Qty_vehicle_verified_Y2014,

count(DISTINCT total <City_of_verification> {<Date_of_Control={'>01/01/2014<=31/12/2014'}, Defect_on=>}Vehicle)

for col3/col5, use

=Qty_defect_Y2013/Qty_vehicle_verified_Y2013

and so on.

4 Replies
Not applicable

Re: sum into a table (without depending dimension)

So what have you tried so far that hasn't worked for you?  Can you share your qvw that shows what you've done so far?

p_gerbaux
New Contributor II

Re: sum into a table (without depending dimension)

Hi Robert

I don't reach to calculate the "qty of vehicle" regardless the dimension " Defect_on".

I tried "aggr" : no success

I tried to find a function "Nofilter" ( as in Business Object) for exclude the dimension "defect_on" : no success

How must i do for displaying the qty of vehicle regardless a dimension in a table?

Thanks for your help

jsaradhi
Valued Contributor

Re: sum into a table (without depending dimension)

for Qty_vehicle_verified_Y2013, use the following expression

count(DISTINCT total <City_of_verification> {<Date_of_Control={'>01/01/2013<=31/12/2013'}, Defect_on=>}Vehicle)

for Qty_vehicle_verified_Y2014,

count(DISTINCT total <City_of_verification> {<Date_of_Control={'>01/01/2014<=31/12/2014'}, Defect_on=>}Vehicle)

for col3/col5, use

=Qty_defect_Y2013/Qty_vehicle_verified_Y2013

and so on.

Re: sum into a table (without depending dimension)

Hi,

Check Enclosed File.

It will help you.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.