topic Re: Roll up value per account in QlikView

Roll up value per account

Wed, 25 Nov 2020 16:16:04 GMT

Hello all,

I would like to create a new column in table where it rolls up to a particular value per account.

All accounts have different support tiers. Some may have more than one type of support tier. I want my newly created column will contain the better support tier per account.

Different types of support tier:

Platinum,

Gold,

Silver,

Basic

For example, if an account has 2 Gold and 1 Platinum, than my newly created column will show Platinum.

For example, if an account has 3 Gold, than my newly created column will show Gold

For example, if an account has 3 Gold and 7 Basic, than my newly created column will show Gold

Please let me know how I can achieve this. Any help is appreciated.

Thank you,

Parth

Re: Roll up value per account

sunny_talwar — Fri, 08 Jul 2016 18:10:01 GMT

May be provide them with numerical values in the script:

LOAD Dual(SupportTier, Match(SupportTier, 'Basic', 'Silver', 'Gold', 'Platinum')) as SupportTier

and then use MaxString(SupportTier)

Re: Roll up value per account

Wed, 20 Jul 2016 15:14:29 GMT

Hi Sunny,

Thank you for your response. This worked

Regards,

Parth