topic Re: How to Group Same Values in a Table? in QlikView

How to Group Same Values in a Table?

Thu, 18 Dec 2014 00:57:04 GMT

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

Thu, 18 Dec 2014 01:00:15 GMT

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

Thu, 18 Dec 2014 01:00:36 GMT

table box shows the rows as it is.

Thu, 18 Dec 2014 01:05:15 GMT

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?

shawn-qv — Thu, 18 Dec 2014 05:57:39 GMT

A Pivot Table ?

Thu, 18 Dec 2014 18:31:55 GMT

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

Salader — Mon, 08 Apr 2019 09:39:19 GMT

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

Salader — Mon, 08 Apr 2019 09:38:27 GMT

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