Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Totals in straight table

Hi all,

I have 8 rows in a straight table and i need only the total of 4 rows in a Total.

How can i achieve this?

Thanks,

Kumar

7 Replies
brunobertels
Master
Master

Hi

In qlik Sense in the panel menue for each mesure select "total function" :

You can select sum , avg etc and None

bruno

Not applicable
Author

It will select the all the rows in the table, i need sum of some rows.

tresesco
MVP
MVP

I guess, that would not be possible natively in qlik sense. You might have to try with extension object.

Not applicable
Author

i have used object2csv extension to export table data to csv. but the total row is not adding up in the exported csv.

what may be the issue?

tresesco
MVP
MVP

May be, numeric fields are being exported as text. You need to change the format to numeric there in the csv/exel itself. Or, ask the extension developer for help.

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Hi,

Can you share how your data and Expected out ?

-Nagarjuna

reddy-s
Master II
Master II

Hi Promoggc3,

Totals will not be included in the export file in excel format. As a work around if you need the totals, try exporting it into PDF format which displays the totals but only the screen is captured and converted to pdf.