Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I group things together from within a field and then show their combined numbers?
Hi James - check out this video:
Qlik Sense - Dimension Grouping (video)
Mike
Other videos: here New to Qlik Sense Videos
Hi James - check out this video:
Qlik Sense - Dimension Grouping (video)
Mike
Other videos: here New to Qlik Sense Videos
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.
If statements worked GREAT! Thanks!