Qlik Community

Ask a Question

Qlik Sense Documents

Qlik Sense documentation and resources.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW

Qlik Sense - Dimension Grouping (video)

Employee
Employee

Qlik Sense - Dimension Grouping (video)

Sometimes it may be necessary to create a new group value consisting of existing values from your data. It may be such where it is not necessary to have this new "dimension" as part of the organizations operational data and may be perhaps temporary.

This technique allows you to consolidate user defined values under a user defined group value that you want to use in your analysis and possibly reuse in a Sense app.

For example, if your company is running a promotion on certain products under a particular manufacturer, you might want to group those manufacturer-like products under a single manufacturer group value to see how they compare with other manufacturers.

  • Create a new dimension in the master items in the Sense app
  • Use the following expression for that dimension:

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

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

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


      8-11-2014 1-23-46 PM.jpg

Watch this video and see attached files to learn more:

Attachments
Comments
Partner
Partner

Hi Michael,


You can use Pick, instead of nested if.

Something like this

IF(wildmatch(PRODNAME,'*Sony*','*Toshiba*','*Samsung*')>0,

PICK(wildmatch(PRODNAME,'*Sony*','*Toshiba*','*Samsung*'),'Sony','Toshiba','Samsung'),

'Other')

And I think it' easier to understand and handle in case of more then 3 manufacturers.

Regards,

Sergey

Employee
Employee

Nice!

0 Likes
Not applicable

Hi Michael,

I am new to the Qlik community, but I have already found your articles very useful. It is important to note that I am using Qlik Sense (not Qlik View). Moreover, I think that Qlik Sense is missing so many basic statistics features right now - the tool can basically be used for descriptive statistics only. Moreover, I would appreciate if you answered two questions:

1. Is it possible to use similar approach to Dimension grouping to create a histogram within the end-user UI?  I know that it is possible to create histogram by defining bins in the import script, but that is such a bad way for a simple end-user creating histograms.

2. Does Qlik Sense has any plan to add an easy-to-use UI interface (I am not talking about import scripts) for creating such things as histograms (this is a must for any business), Trend lines, Standard deviation, some forecast functions and ideally some statistical mean comparison tests?

Thanks and I am looking forward to hearing form you soon!

Best regards,

John

0 Likes
Employee
Employee

Hello John, thank for your comment and for this information. I have informed our products team appropriately. I expect an answer to this shortly, if not to you from them, directly in this post.

Kind Regards,

Mike T

0 Likes
Not applicable

Hi John,


Today Histograms can be created by using the Class() function as a calculated dimension and the Count() function as a measure. E.g.:


Dimension: "=Class(LINEPRICE,5000)"

Measure: "Count(ORDER_NUM)"

That being said, the functionality to offer out of the box histograms, trendlines, and forecasts is on the roadmap.

Thanks.

-Dan

0 Likes
Not applicable

Hi Dan,

Thanks for the answer. I am really, really looking forward to out of the box histograms, trendlines, and forecasts in the future! I think these features will really add value to Qlik Sense.

Thanks,

Reinis

0 Likes
Not applicable

Hi ,

Does this work on Direct Discovery too?

I tried this but it doesnt work

Thanks,

Bhanu

0 Likes
Contributor III
Contributor III

Hi Mike,

Was wondering what I am doing wrong that I get Error in Expression.

here's my expression:

if(WildMatch(Location Description, 'B.B. Upper West Side'), 'West Side',

if(Wildmatch(Location Description, 'B.B. Lower Manhattan'), 'Manhattan',

if(Wildmatch(Location Description, 'B.B. Brooklyn'), 'Brooklyn')))

0 Likes
Employee
Employee

Hi Laleh,

It is the space in "Location Description" - write it like this [Location Description] and you should be ok, I just tested it an it worked.

Also please note - post questions such as these in the main section of the community such as here: New to Qlik Sense that way "others" will see your issue and be able to reply. If you comment on a video, not everyone sees it. 🙂

HTH

Mike

Not applicable

Hi Michael,

Can you please send me again  "world.kml" file .

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2014-08-11 01:00 PM
Updated by: