Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

divyanshi
New Contributor II

how to use group by function in qilksense?

I need to calculate total revenue corresponding to specific  group of customer ?

1 Solution

Accepted Solutions
arvind_patil
Valued Contributor II

Re: how to use group by function in qilksense?

hi Divyanshi,

You may calculate  like below:

Aggr(Sum(Revenue),CustomerGroup)


Thanks,

Arvind Patil

4 Replies
techvarun
Valued Contributor II

Re: how to use group by function in qilksense?

arvind_patil
Valued Contributor II

Re: how to use group by function in qilksense?

hi Divyanshi,

You may calculate  like below:

Aggr(Sum(Revenue),CustomerGroup)


Thanks,

Arvind Patil

divyanshi
New Contributor II

Re: how to use group by function in qilksense?

ok. but I want to add aggregate function in if function ?

How can I apply??

arvind_patil
Valued Contributor II

Re: how to use group by function in qilksense?

Hi Divyanshi,

Please try below one:

If(ID=1 and Name='ABc',Aggr(Sum(Revenue),CustomerGroup),Null())


Thanks,

Arvind Patil

Community Browser