topic Re: Grouping products as a single value in QlikView

Grouping products as a single value

udaya_kumar — Mon, 09 Apr 2012 12:44:45 GMT

Hi,

i have a scenario for Adhoc like,

i have a listbox with product names, when i select few products, then those products should be grouped together as 'other group'

i will have a table,

when i select some values in product listbox, then those selected values are grouped and the volume for those products are calculated and show as one row as 'other group' with its sum(volume).

the table should show those unselected products and that group 'other group' with their corresponding Sum(Volume).

how we can do this?

Re: Grouping products as a single value

SunilChauhan — Mon, 09 Apr 2012 14:09:19 GMT

see the attached file

hope this helps

Re: Grouping products as a single value

SunilChauhan — Mon, 09 Apr 2012 14:12:48 GMT

or may be you are looking for this

see attached file hope this helps

Re: Grouping products as a single value

udaya_kumar — Mon, 09 Apr 2012 14:28:45 GMT

Products	Sum(Volume)
a	100
b	200
c	150
others (d,e)	900

Hi Sunil,

thanks for reply,

ya i want almost that kind of thing, but one more thing in that,

in second file which u uploaded, it shows sum of selected products as some value 900 and

i need unselected products also shown with that group as individual

something like the mentioned table

the grouped products should be shown as others and unselected products should show as different row in the table. and also these products should filter based on markets selected.

there are few markets like biologic, rheum , derm.

the no of products varies based on the market selection.

so here the products should filter based on the market selection and even it should show this grouping.

if i dont group products, if i select some market, then it should show all the products and its volume based on market,

but if i select and group products based on market, then the table should show the products based on market and even the grouping should be shown

Re: Grouping products as a single value

swuehl — Mon, 09 Apr 2012 14:30:25 GMT

If you are using QV11, I think you can do this using dimension limits and two expressions defining your two sets you need. The first expression is only used for the dimension limit and hidden in presentation tab.

Please see attached.

Re: Grouping products as a single value

udaya_kumar — Mon, 09 Apr 2012 14:52:04 GMT

Hi swuehl,

thanks for reply,

i wanted that only, but the problem is, am using pivot table. so dimension limit tab is not visible for pivot table.

i have one more field month name, so am placing that at the top of the table as column. so i need to use pivot table for that.

Re: Grouping products as a single value

swuehl — Mon, 09 Apr 2012 15:11:18 GMT

Ok, here is a different approach not using dimension limits, but partial sums in a pivot and checking for dimensionality().

Re: Grouping products as a single value

udaya_kumar — Mon, 09 Apr 2012 15:24:06 GMT

hi swuehl,

thank u very much for the help

u rock