Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

Re: How to add grouping in straight table

what about using pivot table instead?

Highlighted
Partner
Partner

Re: How to add grouping in straight table

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
Contributor
Contributor

Re: How to add grouping in straight table

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

Highlighted
Partner
Partner

Re: How to add grouping in straight table

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
Contributor
Contributor

Re: How to add grouping in straight table

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,

Highlighted
Partner
Partner

Re: How to add grouping in straight table

Hi Sunil, 


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

Aggr( Only(ID),Plant)