Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sandrapinto
Contributor III
Contributor III

Dimensions based on Total and Aggr

Hi,

I am trying to create a table / bar chart in the UI that shows Sales by a dimension built in the UI.

The dimension is meant to categorize sales by both customer and year: below 50,000 will get group 'A', other wise 'B'.

For ex: customer no. 1 with sales of 10,000 in 2017 will be in group A, while the same customer in 2018 with 60,000 will be in group B.

However, whenever I select "A", i get both 'A' AND 'B', and visa versa.

I also need the Formula to allow use of Set Analysis.

What is wrong here? 

=AGGR(IF(sum({<DataBase={'Customer Orders'}>} TOTAL <CustomerID,Year> Amount) < 50000,'A','B'),CustomerID,Year)

Thank you,

Sandra

11 Replies
sunny_talwar

This is strange, would you be able to share your qvf to check this out?

sandrapinto
Contributor III
Contributor III
Author

qvf is pretty massive

I will have to make some alterations on it to reduce unnecessary and sensitive info. 

It might take some time

will update probably in a couple of days

Thanks a lot for now.

Sandra