Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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
Not applicable

Re: Grouping and subtotaling

Hi James - check out this video:

Qlik Sense - Dimension Grouping (video)

Mike

Other videos: here New to Qlik Sense Videos

Regards,
Mike Tarallo
Qlik
3 Replies
Michael_Tarallo
Not applicable

Re: Grouping and subtotaling

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
Not applicable

Re: Grouping and subtotaling

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

Re: Grouping and subtotaling

If statements worked GREAT! Thanks!