topic Re: Dimension as label for partial sums in pivot table. in QlikView

Dimension as label for partial sums in pivot table.

pavan045 — Thu, 24 Mar 2016 05:23:57 GMT

Hi everyone,

I have a pivot table which need which have 2 dimensions. for the second dimension I am taking partial sums. For partial sum label I wanted to show the corresponding first dimension instead of 'Total'.

In pressentation tab we have 'label for partial sum' option, in which we can write expressions. Any one help me with that?

Thank you.

Re: Dimension as label for partial sums in pivot table.

Chanty4u — Thu, 24 Mar 2016 10:15:28 GMT

is this ?

Re: Dimension as label for partial sums in pivot table.

pavan045 — Thu, 24 Mar 2016 10:29:18 GMT

Yes Chanty, you are right about where I can find that option.

But what I need is, I wanted to show another dimension field name in place of the label of totals.

see the below image.

Here 'fashion' and 'Electronics' are come under a feild productGroup.

I want a pivot table like this in qlikview..

Thank you

Re: Dimension as label for partial sums in pivot table.

Chanty4u — Thu, 24 Mar 2016 11:25:22 GMT

i think taht is not possible as per my knowledge.

if it is static u can pleace the text object over the abve of table with ur Expression

Re: Dimension as label for partial sums in pivot table.

ecolomer — Thu, 24 Mar 2016 11:31:28 GMT

Is this you need?

Re: Dimension as label for partial sums in pivot table.

Kushal_Chawda — Thu, 24 Mar 2016 11:54:55 GMT

see this

Data:
LOAD *, 1 as Flag Inline [
ProdGroup, Product, Amount
Fashion,Jeans,30
Fashion,Shirts,40
Fashion,Shoes,20
Electronics, HeadPhone, 20
Electronics, Camera, 15
Electronics, Mobile, 20 ];

Concatenate
LOAD ProdGroup,
ProdGroup as Product,
sum(Amount) as Amount,
2 as Flag
Resident Data
Group by ProdGroup;

check the Pivot Table Properties

Re: Dimension as label for partial sums in pivot table.

pavan045 — Thu, 24 Mar 2016 12:46:58 GMT

Hi Enrique,

The image you posted is almost similar to what I need. how did you achieve that?.. are you using indent mode?..

can you share an example please.

Thank you.

Re: Dimension as label for partial sums in pivot table.

pavan045 — Thu, 24 Mar 2016 13:05:37 GMT

Hi kush,

Your Idea is really good, But 'Product' and 'Sales' are in different tables(Dimension and fact tables) in my data model. In that case I think it is hard to do it in your way.

thank you.

Re: Dimension as label for partial sums in pivot table.

ecolomer — Thu, 24 Mar 2016 13:17:53 GMT

Yes I use indent mode

I can't upload file but if it is usefull for you I try to simplifly it in order to share with you

Re: Dimension as label for partial sums in pivot table.

ecolomer — Thu, 24 Mar 2016 13:22:04 GMT

Re: Dimension as label for partial sums in pivot table.

Kushal_Chawda — Thu, 24 Mar 2016 13:35:35 GMT

But Your Product Might be a Master Table so can join that table to sales table

Re: Dimension as label for partial sums in pivot table.

Kushal_Chawda — Fri, 25 Mar 2016 05:44:19 GMT

Or instead of join use apply map to bring product and group in sales table