topic Re: Dynamic category based on selection in QlikView

Dynamic category based on selection

kinjal1645 — Sat, 16 Nov 2024 20:15:12 GMT

Hi,

Is it possible to create dynamic category base on user selections?

In above example, I have hard coded "Other" category for Products D,E,F

But my requirement is - For example:

If user selects Product A, B then rest of the possible products should come under category "Other"

If user selects A, D, C then rest of the possible products should come under "Other"

Kindly help!

@sunny_talwar @swuehl @Gysbert_Wassenaar @tresB

Thanks

Re: Dynamic category based on selection

Frank_Hartmann — Sun, 18 Aug 2019 13:12:11 GMT

see attached qvw

hope this helps

Re: Dynamic category based on selection

tresB — Mon, 19 Aug 2019 07:02:33 GMT

Calculated dimension:

Aggr({<Product>} Only({<Product>}If( Index(GetFieldSelections(Product, '|'),Product) Or Len(GetFieldSelections(Product))=0,Product, 'Others')),Product)

Expression:

sum({<Product>}Revenue)

Re: Dynamic category based on selection

sunny_talwar — Mon, 19 Aug 2019 13:00:16 GMT

Here is another option

Create an inline table like this

Dim: LOAD * INLINE [ Dim 1 2 3 ];

and then this

Dimensions

=Pick(Dim, 'Revenue','Income','Expense') =Aggr(If(Product = Only({1} Product), Product, 'Others'), Product)

Expression

Pick(Only(TOTAL <Dim> {1} Dim), Sum({<Product>}Revenue), Sum({<Product>}Income), Sum({<Product>}Expense) )

Re: Dynamic category based on selection

kinjal1645 — Tue, 20 Aug 2019 08:23:33 GMT

Thanks Frank, Tresesco, Sunny