Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

List Box to show amount of categories for products

Hey community,

how can I create a listbox to show the number of category appearances for a given product.

Example:

Product A has 3 categories

Product B 5 categories

and Product C 7 categories.

So the listbox should contain 3, 5 and 7 as values.

At the moment I have a chart with product as dimension and a simple count(category) as expression but I would like to be able to filter the number so that I can select just the products with 3 categories for example.

Can this be done in the load script? What do I need to do?

Thank you,

Thorsten

1 Solution

Accepted Solutions
Partner
Partner

Re: List Box to show amount of categories for products

Hi,

something like the attached sample

View solution in original post

2 Replies
Partner
Partner

Re: List Box to show amount of categories for products

Hi,

something like the attached sample

View solution in original post

MVP
MVP

Re: List Box to show amount of categories for products

Something like below in script...

===

T1:

Load

     Product,

     Category,

     Sales

From ......

Join

Load

     Product,

     Count(Category) as TotalCategory

Resident T1

Group By Product;

===

Now you can use TotalCategory as List Box

Hope this helps..