Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Straight Table: Combining Cells for a Same Value?

Hello!

I have a Straight Table like the following:

ZONEACCOUNT_ID
A001
A002
A003
B001

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

ZONEACCOUNT_ID
A001
002
003
B001

Like grouping a same value and combine the rows?

Thank you!

4 Replies
anandathome
Creator
Creator

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

jonathandienst

Hi

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

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

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

jerem1234
Specialist II
Specialist II

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!