topic Re: Custom Total Row in QlikView

Custom Total Row

Thu, 16 Jun 2011 06:23:19 GMT

Hi all,

How can I add a custom total row into a pivot table? This custom total is not the same as the total of the expression. For example, the expression I use is total count of customer, but in the total row, I want the overall total count of customer AND the total sales amount. I tried adding both into the expression, but the extra expression will repeat in the content of the table. (I only want the total, not the main table) Attached is the sample that I'm working on, and also the desired output in Excel format.

Re: Custom Total Row

pat_agen — Thu, 16 Jun 2011 06:37:54 GMT

hi,

qv will tell you where you are in the pivot table with the dimensionality() function.

Taking your example the lowest cells (intersection of product and expression have dimensionality()=2, the country totals have dimensionality() = 1 and the product totals have it equal to zero.

you can now use and if clause to show different calculations in the same expression at different places in your table.

see attached qvw

Re: Custom Total Row

Thu, 16 Jun 2011 08:23:52 GMT

hi,

But is it possible to create two rows instead of concatenating the two string together?

Re: Custom Total Row

pat_agen — Thu, 16 Jun 2011 08:35:19 GMT

hi,

yes it is, altho' I am not completely sure I have understood your request.

Attached is a qvw with two rows, first expression is sum(Amount) the second is count(Customer) and only displays on the total rows.

hope this helps.

Custom Total Row

Thu, 16 Jun 2011 08:46:35 GMT

Yup.... I want something like this, but the 2nd expression is shown for each dimension... I only need it for the Total row.

Re: Custom Total Row

pat_agen — Thu, 16 Jun 2011 09:05:49 GMT

nearest i can get is attached.

Custom Total Row

Mon, 20 Jun 2011 04:04:25 GMT

Hmmm... this can be use as a temporary solution. If only the Total can be adjusted then it would be great!

Re: Custom Total Row

nagaiank — Mon, 20 Jun 2011 05:04:24 GMT

A modified version using the function secondarydimensionality() instead of dimensionality() is attached which shows total. Is this what you like to see?

Re: Custom Total Row

Mon, 20 Jun 2011 05:13:52 GMT

Hi Kirshna,

The one shown by pat.agen is the one that I want. But you method also works, if I want the total on the left.

The issue now is that the cell height. Currently the sample is using the cell height 2, which make all the cells bigger. (I only want the total row to be bigger, not all the cells)