Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anonymous
Not applicable
Author

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.

View solution in original post

4 Replies
Not applicable
Author

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?

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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.

PrashantSangle

Hi,

Check Enclosed File.

It will help you.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂