topic Re: Straight Table: Combining Cells for a Same Value? in QlikView

Straight Table: Combining Cells for a Same Value?

Wed, 02 Jul 2014 14:54:47 GMT

Hello!

I have a Straight Table like the following:

ZONE	ACCOUNT_ID
A	001
A	002
A	003
B	001

Is there any way to show it like this? Without using a Pivot Table

ZONE	ACCOUNT_ID
A	001
	002
	003
B	001

Like grouping a same value and combine the rows?

Thank you!

Re: Straight Table: Combining Cells for a Same Value?

anandathome — Wed, 02 Jul 2014 15:08:34 GMT

I don't think there is another way (without using Pivot Table) in qlikview to do this.

Re: Straight Table: Combining Cells for a Same Value?

jonathandienst — Wed, 02 Jul 2014 15:10:03 GMT

I am confused by what you want. If you want pivot table appearance, why not use a pivot table?

Jonathan

Re: Straight Table: Combining Cells for a Same Value?

Wed, 02 Jul 2014 15:16:46 GMT

Because I want to use the Sum of Rows in Expression and I don't have the option to do that with Pivot Table

Re: Straight Table: Combining Cells for a Same Value?

jerem1234 — Wed, 02 Jul 2014 15:24:49 GMT

You can use a pivot table like is mentioned above and you can use partial sums. Then if you want, you can have a separate expression for your total like:

if(dimensionality()=0, totalexpression, expression)

Hope this helps!