Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Roll up value per account

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

1 Solution

Accepted Solutions

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)

View solution in original post

2 Replies

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)

View solution in original post

Not applicable

Hi Sunny,

Thank you for your response. This worked

Regards,

Parth