topic Re: Custom Labels in Pivot Table in QlikView

Custom Labels in Pivot Table

Wed, 14 Nov 2012 15:31:13 GMT

Hi all

I've an issue and I need your help! I need to custom the subtotal labels of a pivot table. Imagine a pivot table with 3 dimensions and, for example, the third dimension has two subtotal labels. By default those 2 would have the same name but I need to have different names according to my needs...

I already try an expression like: if(Dimension 2='X', 'Total 1', 'Total2')

The QV always enter in the else part no matter the condition...

There's another way of doing that?

Thanks in advance.

Kind regards,

TMF

Re: Custom Labels in Pivot Table

whiteline — Wed, 14 Nov 2012 18:06:01 GMT

Hi.

You could adopt this approach:

http://community.qlik.com/message/252646#252646

Re: Custom Labels in Pivot Table

Thu, 15 Nov 2012 09:53:02 GMT

Hi whiteline

Thanks for reply. However what I really need is to customize each subtotal label...

TMF

Re: Custom Labels in Pivot Table

whiteline — Fri, 16 Nov 2012 17:24:03 GMT

You can customize all what you want with the approach mentioned above.

Re: Custom Labels in Pivot Table

Fri, 16 Nov 2012 17:35:35 GMT

Hi whiteline

Another time, thanks for answering me!

I can't see how... Can you post a sample file with 3/4 dimensions with the text of subtotals label customized? When I say customize I'm not refering to colors but with text. I want to be able to have a diferent text in each of my 10 subtotal lables...

For the record, I don't want to change the load script. So if there is a way of doing that with change it, I would appreciate.

Best regards,

TMF

Re: Custom Labels in Pivot Table

whiteline — Fri, 16 Nov 2012 17:48:55 GMT

If you read the post carefuly you'll see that 'total' there is just another value of the new field that is used as dimension.

There is no magic, you just add the value that you want and connect it with all values of dimension.

You can use this approach for any number of dimensions separately.

For example, here the new field is used for months grouping:

http://community.qlik.com/message/255186#255186

Re: Custom Labels in Pivot Table

Mon, 19 Nov 2012 09:43:09 GMT

Hi whiteline

I re-read your post again very carefully and I can't find the solution for my problem. Maybe you don't understand my problem or I don't understand how to solve it with your solution.

Either way, if you can post a sample file with subtotal labels customized would be very nice

Kind regards,

TMF

Re: Custom Labels in Pivot Table

Wed, 21 Nov 2012 10:52:00 GMT

I'm in a hurry... Does anyone have another idea/solution?

Thanks in advance.

TMF

Re: Custom Labels in Pivot Table

whiteline — Wed, 21 Nov 2012 19:50:48 GMT

Data:

LOAD * inline [

Dimension1, Dimension2, Value

A, X, 10

A, Y, 15

A, Z, 23

B, X, 32

B, Y, 54

B, Z, 12

C, F, 43

D, G, 24

];

CustomTotals:

LOAD distinct

Dimension1,

Dimension2,

Dimension2 as Dimension2WithTotals

Resident Data;

Concatenate(CustomTotals)

LOAD distinct

Dimension1,

Dimension2,

pick(match(Dimension1, 'A', 'B')+1, 'SubTotals common', 'SubTotals for A', 'SubTotals for B') as Dimension2WithTotals

Resident Data;