Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2011-10-13 01:01 PM

Create dimension based on values of another dimension

I work for an insurance company.  A KPI for us is Premium Revenue by Agent.  I have dimensions for Agent and for Premium.  I want to be able to assign a score of 1 to 5 to each agent based on their premium volume.  For example, if ABC Co. has greater than $5M then they deserve a score of 5.  If less than $5m but greater than $2.5M, they deserve a score of 4.  How do I create the "AgentPremiumScore" dimension and assign the value based on their volume and our scoring criteria? 

662 Views
0 Likes
1 Reply
Not applicable
‎2011-10-13 01:32 PM
Author

Hi  jay,

You can try to create  'Agentpremiumscore' as an additional column while loading your data using the if condition on the Premium.

If(Premium>$5m ,5,if( (Premium>$2.5m and premium <$4.5m),2)

  '

252 Views
0 Likes