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: 
fmazzarelli
Partner - Creator III
Partner - Creator III

delivery

hi community,

I have several years online . What is the formula to extract all kilograms shipped separately in 2011, 2012, 2013, 2014 and in 2015 ?
12 Replies
ogster1974
Partner - Master II
Partner - Master II

COuld youpost some sample data .  So we can help you better.

fmazzarelli
Partner - Creator III
Partner - Creator III
Author

hi,

year, totalKg

2010 1

2010 1

2010 1

2010 1

2011 6

2011 7

2011 1

2011 2

2012 4

2013 1

2013 1

2013 5

2013 20

2014 2

2014 5

I would like to use a kpi

2010                    2011               2012               2013                     2014                    2015

Year 2010               Year               Year               Year                    Year                    Actual  Year

Total 4                    16                    4                    27                         2                         0

ogster1974
Partner - Master II
Partner - Master II

CAnt You pivot on year sum(totalkg)? Unless I'm missing part of your requirement.

Anonymous
Not applicable

Is this you are looking for??

raju_insights
Partner - Creator III
Partner - Creator III

Hi Fabio,

Are you looking for this output

Fabio.JPG

If so, please look at the attached app. You need to generate Years to show 2015 as 0.

shair_abbas
Partner - Creator
Partner - Creator

on script level you can use following script

Load

Sum(totalKg) as totalKg,

Year

from table

group by year;

and on front end just use simple table against this two fields..

OR


on front end chose any graph expect gauge chart then add dimension year and in expression add this

expression sum(totalKg)

fmazzarelli
Partner - Creator III
Partner - Creator III
Author

Hi,

I need s function sum(kg, if(year= 2010) or year=2011, year=2012 year=2013 year=2014 year=2015

fmazzarelli
Partner - Creator III
Partner - Creator III
Author

Hi,

a function similar sumif (Excel)

igdrazil
Creator III
Creator III

Hi Fabio,

you can go with Set Analysis to select one year at a Time like this:

Sum({<Year = {'2010'}>}kg) -> with this you'll get a measure you can use in a KPI which has all KG Values summed of Year 2010

If you need this in a Bar-Chart, you need to use Year as a Dimension and then just sum(KG) against this.

Sadly there is no KPI which shows many numbers at a time, so you'll need to use the Pivot-Table to do this, which works same as the Bar-Chart version.

Hope i helped you!

Regards

Chris

P.S.: Please mark Helpful/Correct Answers as such.