Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Grouping and subtotaling


How do I group things together from within a field and then show their combined numbers?

1 Solution

Accepted Solutions
Michael_Tarallo
Employee
Employee

Hi James - check out this video:

Qlik Sense - Dimension Grouping (video)

Mike

Other videos: here New to Qlik Sense Videos

Regards,
Mike Tarallo
Qlik

View solution in original post

3 Replies
Michael_Tarallo
Employee
Employee

Hi James - check out this video:

Qlik Sense - Dimension Grouping (video)

Mike

Other videos: here New to Qlik Sense Videos

Regards,
Mike Tarallo
Qlik
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try to create a new dimension like this

Master Items -> Dimension -> Create New

     if(wildmatch(PRODNAME,'*Sony*'),'Sony'

          if(wildmatch(PRODNAME,'*Toshiba*'),'Toshiba'

               if(wildmatch(PRODNAME,'*Samsung*'),'Samsung','Other'))) 


OR in script load data like this


LOAD

*,

if(wildmatch(PRODNAME,'*Sony*'),'Sony'

          if(wildmatch(PRODNAME,'*Toshiba*'),'Toshiba'

               if(wildmatch(PRODNAME,'*Samsung*'),'Samsung','Other')))   AS Company

FROM DataSource;


OR Use and external file to link the Product and Company


LOAD

PRODNAME,

Company

FROM Mapping.xls;


Now use Company dimension for grouping.


Also watch this Qlik Sense - Dimension Grouping (video) it is very helpful.


Hope this helps you.


Regards,

Jagan.

Not applicable
Author

If statements worked GREAT! Thanks!