Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

How to Group Same Values in a Table?

Hi,

I have a table with the same values for a particular dimension (Campaign) in this case. How do I group the same values into one row?

Thanks!

-Jason

Tags (3)
1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: How to Group Same Values in a Table?

if you do a chart say straight table and choose campaign as the dimension it will not display duplicates.

View solution in original post

7 Replies
Highlighted
Not applicable

Re: How to Group Same Values in a Table?

if you do a chart say straight table and choose campaign as the dimension it will not display duplicates.

View solution in original post

Highlighted
Not applicable

Re: How to Group Same Values in a Table?

table box shows the rows as it is.

Highlighted
Not applicable

Re: How to Group Same Values in a Table?

So there's no way to group the same campaign that shows up multiple times in my raw data file into one row in Qlike Sense?

Highlighted
Contributor

Re: How to Group Same Values in a Table?

A Pivot Table ?

S.

Highlighted
Not applicable

Re: How to Group Same Values in a Table?

Thank you, I made the mistake of adding additional dimensions as columns instead of measures. Once I switched, the problem was solved, thank you!

Highlighted
New Contributor

Re: How to Group Same Values in a Table?

That's not true, as I'm getting duplicates on column 'fecha':

 

Highlighted
New Contributor

Re: How to Group Same Values in a Table?

That's not true, as I'm getting duplicates on column 'fecha':