Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Grouping Field Values in Qlik Sense 3.2

Hi, I have a column name ''vehicle_type" under which I have multiple model names such as ''Accent'',''Baleno'',''Truck'',''Motorbike'' and so on. There are over 100+ models/vehicle types such as these mentioned. There are 2 objectives that I need to achieve.
Objective 1: Need to create only one dimension called ''Car'' under which only car models must be present (eliminating/ restricting ''truck'',''Motorbike'' etc)
Objective 2: Need to create a radio button that shows only ''Car'' and not all the values under ''Car''. Right now I get all the models listed as a radio button.
I've managed to achieve objective 1 but stuck at obj 2.

TIA

5 Replies

Re: Grouping Field Values in Qlik Sense 3.2

Create a new field in the load script in the table that tells what group of types the model/type belongs to. You can then use that new field to select the value Car in.


talk is cheap, supply exceeds demand
Highlighted
Not applicable

Re: Grouping Field Values in Qlik Sense 3.2

precisely there are 260 vehicle types out of 300 which I have identified as car. Is it possible to create this on the fly? creating a new field in the load script may be a time consuming job.

Re: Grouping Field Values in Qlik Sense 3.2

Doing it on the fly will probably be more time consuming. I don't know how your identifying process works. If that can't be automated I suggest using an excel file and update that as you identify new cars. Then load the excel file into the Qlik Sense app.


talk is cheap, supply exceeds demand
Not applicable

Re: Grouping Field Values in Qlik Sense 3.2

Hi Gysbert,

I appreciate your response. I'm new to Qlik Sense and I carry a rich experience working on variety of self-service tools. I felt many features were missing in Qlik Sense and I don't expect many to be incorporated soon but at the same time I would expect basic features to be in place to showcase good value proposition to the end user. I liked Qlik Sense in many ways due to its light architecture, simple setup process, good ETL layer, data storytelling and much more. The above scenario that I mentioned is just a tip of the iceberg. If I want to create multiple grouping from different levels of categories and sub categories, this adds up to the complexity. It's Qlik Sense and business users usually doesn't know or least bothered to get into back-end to create scripts.

Re: Grouping Field Values in Qlik Sense 3.2

Perhaps you can use bookmarks. Select everything you think is a car and then create a bookmark to save that selection in.


talk is cheap, supply exceeds demand