Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Showing total of only subtotals

Hi,

I'm busy with a pivot table.
Now I can easily showing the subtotals of rows.
But now I want to make a total of these totals, how is this possible?

Example:

Prod                         Belgium          Netherlands           Total        

ProductA                         5                    5

ProductB                         5                    6

ProductC                         6                    2

Total                               16                   13                    29                   

Regards

6 Replies
sridhar240784
Creator III
Creator III

I'm not sure, I have understood your question

Properly.

to identify the difference between total and subtotal

You may use dimensionality() and secondarydimensionality()

Functions

You may play around with these functions.

Hope this helps you.

-Sridhar

Message was edited by: Sridhar Ethiraj

udit_kumar_sana
Creator II
Creator II

Hi,

Please find here the attached file for the solution.

By this you will get total in all the rows of last column.

In order to show total at last row only.

-go in view option ,select  design grid.

-place the cursor over last column data and right click choose custom format cell option ,there choose text color weight.

-this will give you just total in last column.

-to remove background grid deselect from view ,the design grid option.

Regards,

Udit

udit_kumar_sana
Creator II
Creator II

sorry, choose the text color white.

Not applicable
Author

hi using try .

if (Dimensionality() = 0,

sum( total Belgium) + sum(total Netherland))

regards

GERNAN

Not applicable
Author

I don't really understand you.

Should I make a new expression => Total with following statement:

if (Dimensionality() = 0,

sum(MISTotaal)

When I use this expressions, it gives me after every "country" a blank line.

Not applicable
Author

this is my example . i think it helps for you

untitled.PNG

Belgium as Bel

Netherlands as Neth

i use expression in the TOTAL is

if (Dimensionality() = 0,

sum( total Bel) + sum(total Neth))

GERNAN