Grouping and subtotaling

[#1]

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

[Michael_Tarallo · Accepted solution]

Hi James - check out this video:

Qlik Sense - Dimension Grouping (video)

Mike

Other videos: here New to Qlik Sense Videos

[jagan]

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.

[#4]

If statements worked GREAT! Thanks!