Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

pooja821
New Contributor III

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
chauhans85
Esteemed Contributor

Re: revenue for specific group of customers

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

pooja821
New Contributor III

Re: revenue for specific group of customers

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

antoniotiman
Honored Contributor III

Re: revenue for specific group of customers

Hi Pooja,

try

Calculated Dimension :

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

Expression : Sum(rev)

Regards,

Antonio

chauhans85
Esteemed Contributor

Re: revenue for specific group of customers

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

antoniotiman
Honored Contributor III

Re: revenue for specific group of customers

I'm sorry, I add '

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

Community Browser