Sum only a certain category of a column

[#1]

Hey everbody,

I'm totaly new to Qlik Sense and after I did the tutorials provided on the qlik sense website I'm trying to produce my first app.

I have an excel file which contains all the information I need.

But now I'm facing my first prob.

The excel file contains data like "category", "€", "project", "year" and "montht".

Now I want to sum up only a certain category

For example like this:

Project	€	Category
10010	5.000 €	Turnover
10010	3.000 €	Material cost
99999	10.000 €	Turnover
99999	8.0000 €	Material cost
10010	1.000 €	HR cost
99999	500 €	HR cost

Now I want to sum up all values of "€" of the category "Turnover". So the result would be 15.000 €

In excel I would do it like =sumif(A2:C7;"Turnover"B2:B7") but how does this work for qlik sense?

Thanks in advance!

Andy

[OmarBenSalem · Accepted solution]

Add a chart with a measure : sum(€)

and then add your dimension Category in the sheet (just drag it);

now select Turnover and you'll have your result:

If you want to just specify on Categroy Turnover without filtering :

use this expression :

Sum({<Category={'Turnover'}>}[€])

please refer to these thread, it contains valuable explanations:

https://community.qlik.com/message/1252442?et=watches.email.thread#1252442

YTD, MTD issue

See the attached App (to use the app, you put it under : C:\Users\YourUser\Documents\Qlik\Sense\Apps

[brunobertels]

Hi Andreas

Welcom to Qlik sense

For your mesure try this :

Sum({$<Category={'Turnover'}>}€)

This mesure is called a set analysis see below further information

https://community.qlik.com/blogs/qlikviewdesignblog/2015/02/16/set-analysis

As set analysis can be complicated

See this DOC for détails about set analysis

https://community.qlik.com/docs/DOC-4951

Look here , it's a set analysis wizard that will help you to built your set analysis

http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx?sa=

hope it helps

Bruno

[#4]

Hello everbody,

first of all - Thanks for all the replies!!

I've been to a short trip over the weekend, because of this I couldn't give it a try.

I'll try the Sum function within the next hours and give you a feedback.

best wishes

Andy