Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Sunil
Contributor
Contributor

How to add grouping in straight table

I have data like below in straight table.

ID     Plant

10    A

10    B

10    C

20    A

20    B

20    C 

I would like to make group by ID as shown below

ID     Plant

          A

10     B

           A

20      B

           C

 

Can anyone please suggest

       

Spoiler
Spoiler
 

 

6 Replies
agigliotti
Partner
Partner

what about using pivot table instead?

Vegar
MVP
MVP

What are you trying to accomplish? Is there a reason why you can not use a pivot table?

Sunil
Contributor
Contributor
Author

Basically I am using Simple table extension, the reason using this extension is I have to show image in table as well. 

Vegar
MVP
MVP

So your question is on how to get the desired output in a table generated by the Simple  table extension?

Sunil
Contributor
Contributor
Author

Yes,

My requirement is I have to show all functionality as give below in same table.

  1. Need to show image based on expression
  2. Need to apply conditional color logic for selected coloum
  3.  Need to group by Dimension rather than repeating same value in multiple rows.

Thanks,

tomovangel
Partner
Partner

Hi Sunil, 


Can you try this as dimension maybe it will work for you

Aggr( Only(ID),Plant)