Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Valued Contributor

Re: Totals in straight table

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

Re: Totals in straight table

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

MVP
MVP

Re: Totals in straight table

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

Not applicable

Re: Totals in straight table

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?

MVP
MVP

Re: Totals in straight table

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
Valued Contributor II

Re: Totals in straight table

Hi,

Can you share how your data and Expected out ?

-Nagarjuna

reddys310
Honored Contributor II

Re: Totals in straight table

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.