Group Products in chart

[shiveshsingh]

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

[shiveshsingh]

Please help..anyone?

[tomasz_tru]

Maybe for the dimension:

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

Tomasz

[jyothish8807]

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,

KC

[shiveshsingh]

Thanks, but I'm afraid this would not work

[shiveshsingh]

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?

[rajivmeher]

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.