topic Qlik Aggregation in QlikView

Qlik Aggregation

Wed, 25 Nov 2020 16:16:04 GMT

Hi guyz

I tried and searched but could not come to conclusion

In Qlikview Can we aggregate row wise

Eg:

Suppose have columns Student,English,Maths,Science

I need Sum of English, maths,Science

Thanks

Re: Qlik Aggregation

ziadm — Thu, 03 Nov 2016 17:20:39 GMT

You can create a unique key for each row and then aggregate based on that Key

for example you key might be StudentID + Subject

this way your aggregation will be based on student and subejct

You may share sample data in order to clarify this

Re: Qlik Aggregation

MK9885 — Thu, 03 Nov 2016 17:38:38 GMT

sum({<Student={'English'}>} StudentID)

sum({<Student={'Math'}>} StudentID)

....

Student is a field which has values Math, English, Science etc..

And StudentID is your unique field. It will calculate only English from Student field..

There might be a better way to do it, search in community or maybe an expert can help you?

Re: Qlik Aggregation

Fri, 04 Nov 2016 04:49:07 GMT

Guyz I want like English+Science+MAths

Eg: Stud_Id,Eng,Math,Sci

101,88,75,80

I need to calculate 88+75+80

Re: Qlik Aggregation

varshavig12 — Fri, 04 Nov 2016 06:13:52 GMT

you can try this:

CrossTable(Subject, value)

LOAD * INLINE [

student, Maths, ENglish, Science

a, 10, 20, 30

b, 40, 50, 60

c, 25, 47, 35

];

In presentation- show partial sum.

simply:

LOAD * INLINE [

student, Maths, ENglish, Science

a, 10, 20, 30

b, 40, 50, 60

c, 25, 47, 35

];

Hope this helps!

Re: Qlik Aggregation

Fri, 04 Nov 2016 06:35:17 GMT

Thanks

It was Really Helpful

Re: Qlik Aggregation

MK9885 — Fri, 04 Nov 2016 13:16:03 GMT

Can you please tell us what is field name where you've these values?

Maybe you can use

sum({<[FieldName1]={'Eng'}>}FieldName2)

+sum({<[FieldName1]={'Math'}>}FieldName2)

+sum({<[FieldName1]={'Sci'}>}FieldName2)

Field Name1 = Your filed where you've these values (Eng, Math, Sci)

FieldName2 = Can be your unique key field (Maybe student number or whatever you have)

Can you tell me what is the field name you have for Eng, Math,Sci? and a unique key?

Or it will be much better if you can provide a sample.