topic Group Products in chart in QlikView

Group Products in chart

shiveshsingh — Wed, 25 Nov 2020 16:16:04 GMT

Hello All

I have a product dimension having 3 products(INTERNET, NLD, MPLS). Expression is shared below.

=if (Products='INTERNET' ,count(Aggr(If(sum(Values) >= $(vInternet),DMU_NAMES),Products, DMU_NAMES,Month)),

if (Products='NLD' ,count(Aggr(If(sum(Values) >=$(vNLD),DMU_NAMES),DMU_NAMES,Products,Month)),

if (Products='MPLS' ,count(Aggr(If(sum(Values) >=$(vMPLS),DMU_NAMES),DMU_NAMES,Products,Month))))

Now instead of INTERNET, NLD, MPLS as product names, i just need a single name in chart say MAXIS as Product(Which is group of INTERNET +NLD + MPLS).

Please suggest a way out.

Product	Count
MAXIS	Calculated_Value

Re: Group Products in chart

shiveshsingh — Wed, 12 Sep 2018 11:22:49 GMT

Please help..anyone?

Re: Group Products in chart

tomasz_tru — Wed, 12 Sep 2018 11:31:38 GMT

Maybe for the dimension:

=If(Match(Products,'INTERNET', 'NLD', 'MPLS'),'MAXIS','Others')

Tomasz

Re: Group Products in chart

jyothish8807 — Wed, 12 Sep 2018 11:35:47 GMT

Make a inline table:

Load * Inline [

NewProdName, Products

MAXIS, INTERNET

MAXIS, NLD

MAXIS, MPLS

];

Now you can take take both NewProdName and Products as dimension. Then you can Hide Products dimension and use the same expression if that is your requirment.

Br,

Re: Group Products in chart

shiveshsingh — Wed, 12 Sep 2018 12:03:10 GMT

Thanks, but I'm afraid this would not work

Re: Group Products in chart

shiveshsingh — Wed, 12 Sep 2018 12:04:35 GMT

Hi Jyotish

Thanks but i've already tried this way in sense..sorry but this is for Qliksense not view.

Can we have a wayout here in sense?

Re: Group Products in chart

rajivmeher — Wed, 12 Sep 2018 12:56:55 GMT

Hi shiveshsingh‌

Please try the following:

For product use:

=If(Match(Products,'INTERNET', 'NLD', 'MPLS'),'MAXIS')

For count use:

=if (

MATCH(Products,'INTERNET','NLD', 'MPLS')

, count(

Aggr(

If(sum(Values) >= $(vInternet) + $(vNLD) + $(vMPLS), DMU_NAMES

)

, Products, DMU_NAMES, Month

)

Regards

Rajiv.