Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Qlik Insider - Maximize your investment, Join this webinar, May 26th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
yossi_bire
Contributor II
Contributor II

Set Analysis based on Rank

Hi,

I'm struggling with this issue for several days.

I want to calculate the Total value of the N customers with the same conditions.

Meaning, first calculate the total sale per Customer with some conditions (set analysis), then rank them, and finally sum the total sales for the first N top customer. the N is a variable the can be changed by the user.

somthing like this

sum(<{Field1={''},field2={''}, Customer = { Rank( sum(< {Field1={''},field2={''} > Sales } <= $(NTopCustomer))} Sales)

thanks

1 Solution

Accepted Solutions
sunny_talwar

Try this

Sum({<Field1 = {''}, field2 = {''}, Customer = {"=Rank(Sum({<Field1 = {''}, field2 = {''}>} Sales)) <= $(NTopCustomer)"}>} Sales)

View solution in original post

15 Replies
sunny_talwar

Try this

Sum({<Field1 = {''}, field2 = {''}, Customer = {"=Rank(Sum({<Field1 = {''}, field2 = {''}>} Sales)) <= $(NTopCustomer)"}>} Sales)

View solution in original post

yossi_bire
Contributor II
Contributor II
Author

at first, it didn't work, but I found out what was the problem

one of my conditions is based on a variable

[DATE.autoCalendar.QuartersAgo]={"<=$(DateRangeSelection)"}

your answer works perfectly without it, any suggestion?

sunny_talwar

What are Field1 and field2? Are these placeholders for your actual fields or that is what they are called? If they are the real field names, make sure you have the correct casing for them... meaning is field2 called Field2? or may be Field1 is called field1...

There could be many things which could be not right... difficult to say what might be issue more details. Are you able to share a sample if what I mentioned above is not an issue

yossi_bire
Contributor II
Contributor II
Author

my conditions are

[DATE.autoCalendar.QuartersAgo]={"<=$(DateRangeSelection)"} , [CHANNEL]={'DIRECT'}

sunny_talwar

May be try one of these

[DATE.autoCalendar.QuartersAgo]={"<=$(=DateRangeSelection)"}

or

[DATE.autoCalendar.QuartersAgo]={"<=$(=$(DateRangeSelection))"}

yossi_bire
Contributor II
Contributor II
Author

nope still -

sunny_talwar

How do you define DateRangeSelection?

yossi_bire
Contributor II
Contributor II
Author

it's working in the set analysis outside the Rank

it's a variable that gets the value from the extension "Variable Toggle" and the options are:   0 , 3 , 7

sunny_talwar

Have you checked that the variable actually takes a value once you set it using your extension? Check the variable overview and see what value do you see for DateRangeSelection variable