Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pooja821
Creator
Creator

revenue for specific group of customers

I need to create ACCOUNTS TYPE column under which there are three sub columns i.e. TAIL ACCOUNT(rev <1 Mn) , MIDDLE ACCOUNT(rev b/w 1 to 5 Mn) and LARGE ACCOUNT (rev >5 Mn)

So I need to compare revenue value in order to create these account types corresponding to the customer groups which might have same customer multiple times having different revenue values. So do I calculate revenue in order to divide them into these three groups and create these columns.

5 Replies
SunilChauhan
Champion
Champion

as i understand, you can create cross table for  account type and values

result would be like below

Account type, Value

TAIL ACCOUNT(rev <1 Mn),.5m

MIDDLE ACCOUNT(rev b/w 1 to 5 Mn),1.5m

LARGE ACCOUNT (rev >5 Mn),7Mn

Sunil Chauhan
pooja821
Creator
Creator
Author

I want one column i.e. account type under which there would three sub columns i.e. tail,middle and large.

antoniotiman
Master III
Master III

Hi Pooja,

try

Calculated Dimension :

Aggr(If(rev < 1000000,'TAIL ACCOUNT',If(rev < 5000000,'MIDDLE ACCOUNT','LARGE ACCOUNT)),ACCOUNT)

Expression : Sum(rev)

Regards,

Antonio

SunilChauhan
Champion
Champion

Test:

CrossTable(AccountType,Values,1)

Load * inline [

Id,TAIL ACCOUNT(rev <1 Mn),MIDDLE ACCOUNT(rev b/w 1 to 5 Mn),LARGE ACCOUNT (rev >5 Mn)

1,.5,1.5,7

];

Load

AccountType,

Values,

Id,

'Account Type' as header

resident Test;

drop table Test;

take Id, AccountType,header in dimension and sum(Values) in expression

Sunil Chauhan
antoniotiman
Master III
Master III

I'm sorry, I add '

Aggr(If(rev < 1000000,'TAIL ACCOUNT',If(rev < 5000000,'MIDDLE ACCOUNT','LARGE ACCOUNT')),ACCOUNT)