Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Creating Sub-Categorises From A Number of Field Values

Hello All,

I am trying to make sub-categorises from a number of field values.

For example, I might have the following column:

Item [Field Name]

Conditioner [Field Value]

Shampoo ["]

Hair Gel ["]

Bread ["]

Cheese ["]

I would like to make a sub-category from this data. Like, group all the hair care products into one category called Hair Care Products.

I have tried to do this using a set expression in the UI:

Sum({$<Item={'Conditioner', 'Shampoo', 'Hair Gel'}>}[TABLE NAME]).

When I drag this into the canvas it produces a numerical value, i.e. not what I want.

I have considered using the wildcard function, would this be advisable?

Thank you all in advance,

Alison

1 Solution

Accepted Solutions

Re: Creating Sub-Categorises From A Number of Field Values

I suggest to create such categories within the script maybe with a small inline-table like:

load * inline [

Item, Category

Shampoo, Hair Care Products

Hair Gel, Hair Care Products

...

];

and then to use this category within your objects.

- Marcus

2 Replies

Re: Creating Sub-Categorises From A Number of Field Values

I suggest to create such categories within the script maybe with a small inline-table like:

load * inline [

Item, Category

Shampoo, Hair Care Products

Hair Gel, Hair Care Products

...

];

and then to use this category within your objects.

- Marcus

Not applicable

Re: Creating Sub-Categorises From A Number of Field Values

Hi Marcus,

Great, that works! Thanks a lot!