topic Re: Total Label repeats on each dimension column after export to excel in QlikView

Total Label repeats on each dimension column after export to excel

Mon, 21 Jan 2013 07:46:39 GMT

Dear all,

Any one have any idea if this is the native bahavior ?

Any idea if it is possible to let the label show once ONLY ?

Thanks

1.) Created a straight table with TOTAL and type in TOTAL Label

2.) Then Export to Excel as got the following:

Re: Total Label repeats on each dimension column after export to excel

Mon, 21 Jan 2013 08:40:54 GMT

I don't know if this is the usual behaviour of QV. But an idea for a workaround could be to label the second column with a space ' ', which would be invisible at export.

// sebablum

Re: Total Label repeats on each dimension column after export to excel

Mon, 21 Jan 2013 08:56:04 GMT

Sebablum, thanks for your reply.

What you mentioned could be done in Pivot table but not in Straight Table.

In Stranght Table, there is only one place for you to define the Total Label.

Re: Total Label repeats on each dimension column after export to excel

Mon, 21 Jan 2013 10:52:34 GMT

Yes I see. Sorry, but I don't know a way out then. Maybe you should use Pivot Table and activate "Always fully expanded"?

Regards,

sebablum

Re: Total Label repeats on each dimension column after export to excel

Mon, 21 Jan 2013 10:59:00 GMT

No worry, it is good to exchange ideas because this always stimulate thought!

Change it to Pivot Table could be a solution but in my case, cannot because due I have to hide some columns while Pivot Table do not have Hide Column option.

Thanks for your sharing!!

Re: Total Label repeats on each dimension column after export to excel

Anonymous — Mon, 21 Jan 2013 11:08:02 GMT

Is EMPNO set as a dimension ? If so, trying setting as an expression only(EMPNO) and then setting no total for it.

Jonathan

Re: Total Label repeats on each dimension column after export to excel

Tue, 22 Jan 2013 02:24:11 GMT

Thanks Jonathan. My example above is just a sample and in my case, the straight table object is not that simple.

Seems like this is the native behavior of Qlikview and can only be solved using some work arounds like your suggestion.

Thanks again