Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
RichardLee
Creator
Creator

Group Data in a Table

I need some help on this, I'm still new to Qlik and I have a table of data in a chart. I need to group the Data with out making it a Pivot could somebody help?

Labels (3)
1 Solution

Accepted Solutions
Or
MVP
MVP

In a table, data will be grouped on the full list of dimensions, not just the first one. There is likely another dimension in the table that is causing those rows to be split.

View solution in original post

4 Replies
Or
MVP
MVP

Data will automatically be grouped in a chart based on the dimensions selected and the aggregation functions used, e.g.

Dimensions: Year, Month

Measure: Sum(Sales)

Data will be grouped by Year and Month.

RichardLee
Creator
Creator
Author

I need the name to be grouped and its not doing this automatically.

 

RichardLee_0-1652255219282.png

 

 

Or
MVP
MVP

In a table, data will be grouped on the full list of dimensions, not just the first one. There is likely another dimension in the table that is causing those rows to be split.

RichardLee
Creator
Creator
Author

Yes its my fault I had I Dimension in-between measures. All sorted.