Requirement of header for each division with tota... - Qlik Community

vikasmahajan · ‎2014-08-25

Dear All,

I have a pivot table as per attached format , I want to display totals of each division as dimension name + 'Total' as total

is this possible.

Please advise.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

tresesco · ‎2014-08-25

Not exactly what you want like. But with indent mode(styel tab) you can get something like attached sample qvw.

avinashelite · ‎2014-08-25

Hi ,

Please see the attachment, hope this helps you.

Regards,

@vi

Report Inappropriate Content · ‎2014-08-25

Hi,

I don't know this is what you are looking for or not, trying giving this in your expression.

If(Dimensionality()=1,'Total ' & Division& ' ' & num(sum(AnnualTarget),'#,##0'),num(sum(AnnualTarget),'#,##0'))

Hope it helps!

Thanks,

Sindhu

vikasmahajan · ‎2014-08-25

Thanks for reply but this is not my requirement I want to display "Total A " , "Total B " as label for total for each division

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

vikasmahajan · ‎2014-08-26

Any one guide me how to resolve this ?

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

avinashelite · ‎2014-08-26

Hi Vikas,

As per my knowledge its not possible to give different headings for sub totals .

jagan · ‎2014-08-26

Hi Vikas,

Check this thread

Sub Total Handling

Hope it helps you.

Regards,

Jagan.

Requirement of header for each division with totals