Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

caolu1995
New Contributor

how to classify according to the sum amount

1550910262036.jpg

1550910278857.jpg

Hi all,

The first table is my original data and I am trying to classify the amount of contracts. I used the function called count distinct to calculate the number of the clients, but it showed like below:1550910457333.jpg

 

I know where the problem is, it seems that the dimension is not sum of the amount if it is from the same client. It should be like the second table.  I created a new dimension which function is : but it's not working.

=if(sum([contract amount])<'100000', '小于十万', 
	if(sum([contract amount])>'1000000','大于百万','十万至百万'))

anyone can help me solve this kind of problem? Maybe I should use the aggravation function?

 

 

 

Labels (2)