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: 
rahulsud007
Creator
Creator

Sum and Count at the bottom of the same table.

Dear all

I have requirement in which I need count of items and sum of items in the bottom row as mentioned in the image in a straight or pivot table.

But in Single object not in multiple objects.

Please suggest me.

      

35 Replies
sunny_talwar

Hey jagan‌ - One quick question. I know why you added ADD (because you might have done a partial reload). What is ONLY used for here (Never used it or seen it getting used)

Thanks,

Sunny

jagan
Luminary Alumni
Luminary Alumni

If it is not possible in direct method, we need to go in indirect method like this by changing script and changing expressions Sunny!!!!!

Regards,

Jagan.

jagan
Luminary Alumni
Luminary Alumni

Only ADD:

Tab1:

LOAD Name, Number FROM Persons.csv;

ADD LOAD Name, Number FROM newPersons.csv;

During normal reload, data is loaded from Persons.csv and stored in the

QlikView table Tab1. Data from NewPersons.csv is then concatenated to the

same QlikView table.

During partial reload, data is loaded from NewPersons.csv and appended to

the QlikView table Tab1. No check for duplicates is made.

Tab1:

LOAD Name, Number FROM Persons.csv;

ADD ONLY LOAD Name, Number FROM NewPersons.csv Where not exists(Name);

During normal reload, data is loaded from Persons.csv and stored in the

QlikView table Tab1. The statement loading NewPersons.csv is disregarded.

During partial reload, data is loaded from NewPersons.csv which is appended

to the QlikView table Tab1. A check for duplicates is made by means of

seeing if Name exists in the previously loaded table data.

Hope this helps you.

Regards,

Jagan.

sunny_talwar

100% Agreed and I always vouch for script changes rather than putting a lot of my time on the front end.

sunny_talwar

I was under the impression that ADD and REPLACE only work with Partial Reload, i.e., the table with ADD and REPLACE keywords are disregarded. I guess I need to check the partial reload basics.

sunny_talwar

Thanks for the clarification jagan