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.

      

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi Rahul,

Please find attached file for solution.

Regards,

Jagan.

View solution in original post

35 Replies
gautik92
Specialist III
Specialist III

you can  select only one option i hope either total or count

Untitled.png

mightyqlikers
Creator III
Creator III

Hi Rahul

create another chart for count with same dimensions and put it under that .

Sam

rahulsud007
Creator
Creator
Author

Hi gautik92

Thanks for your quick response,  unfortunately I need both the fields sum as well as count.

rahulsud007
Creator
Creator
Author

Hi Sam,

but I need it in single Object and that too in tabular format.

gautik92
Specialist III
Specialist III

not possible

rahulsud007
Creator
Creator
Author

Is there any alternative, suppose v can do anything in back end to achieve this

gautik92
Specialist III
Specialist III

Unfortunately it is not possible

mightyqlikers
Creator III
Creator III

i hope you can create another chart

allign it properly bottom of first chart.    

kuczynska
Creator III
Creator III

I think you can try to create (let's call it this way) "synthetic dimension". So field call "Total" in your load script. You can make it look like a default Total row by changing the Text format options in both dimensions and expressions.

The way I prefer is to concatenate a template table with 0 values as all of the dimensions. Have a look at the QVW, maybe it will be of any use to you.