topic Re: Merge cells in QlikView

Merge cells

Thu, 24 Jul 2014 08:04:54 GMT

Hello everyone,

It seems that the topic of "Merging Cells" is a known issue to Qlikview users, and I am also having some trouble with this.

On the example I have attached there is a straight table. On this table, the column "Description" has repeated values, as well as the "Stat" column and the "aggr" column.

But I would like to merge the cells with the repeated values like on the attached image.

Is there a way to do this in Qlikview?

Thank you for the support!

Best regards

Re: Merge cells

Thu, 24 Jul 2014 08:55:09 GMT

Hi Ivo,

the straight table will always populate repeat each row like that yes, you will need to convert to a pivot table instead(like in your image) to result in one entry for each description.

Please note though, that even if you change to a pivot, if you then try to export this to excel, it will populate each row again in the output

hope that helps

thanks

Joe

Re: Merge cells

israrkhan — Thu, 24 Jul 2014 09:48:38 GMT

find the attachment, see om Sheet 2 as well.

Hope it help

Re: Merge cells

SunilChauhan — Thu, 24 Jul 2014 09:59:27 GMT

why not use Pivot table like attched

Re: Merge cells

VishalWaghole — Thu, 24 Jul 2014 11:18:38 GMT

Hi,

Only use pivot table instead of straight, your problem will be solve.

-- Regards,

Vishal Waghole

Re: Merge cells

Thu, 24 Jul 2014 12:54:13 GMT

So, I was able to make the "merge cells" with the pivot table, but I have another problem.

I would like to remove the last column "count", because it does not make sense to be there, but this column is comes from a expression and if I delete it the table does not load the results...

In attachment is the current state. I only have the personal edition of QV so if you change something and save with the professional edition I will not be able to open it.

Thank you for the help!

Re: Merge cells

Thu, 24 Jul 2014 13:08:53 GMT

Hi Ivo,

can't send you qvw I'm afraid but I think I know what you are after, all the rows but the overall total for each description?

If you remove your calculated dimension and count, then replace with new expression

count(total<Description> Number)

that should give you the answer.

Hope that helps

Joe

Re: Merge cells

Thu, 24 Jul 2014 13:33:23 GMT

Yes this way it works properly

Thank you everyone for the help!!

Re: Merge cells

Thu, 12 May 2016 22:44:05 GMT

Hi, JoeSimmons,

in the above table if I want to show value 1025 & also count just once for Text A: Description.... How can I do that?

and in my case both 1025 and count is an expression.

Thanks