Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
marcus_steggall
Creator
Creator

Whale Curve, not showing expected view!

Hi all, happy monday

I'm having a slight issue with trying to create a whale curve.

As you can see from my attached qvw, it's not exactly looking the curve result.

Have tried following, the example given in the link below, but just cannot see where i'm going wrong.

http://www.qlikfix.com/2010/11/10/visualizing-customer-profitability-with-a-whale-curve/

I do have multiple values, per customer which may mean bringing in a distinct function, but it's hard to know whether this show's the correct view.

Any help, would be much appreciated.

1 Solution

Accepted Solutions
sunny_talwar

Check for max using this on the presentation tab

=num(Sum(Aggr(If(Sum(Amount) > 0, Sum(Amount)), [Customer Name])),'#,##0')


Capture.PNG

View solution in original post

5 Replies
sunny_talwar

I think you have used amount (with a lower case A) vs. Amount (your actual field name) which caused this issue for you.... May be look at this

Capture.PNG

marcus_steggall
Creator
Creator
Author

Hi Sunny,

Appreciate the reply, ahhh something so simple to get the graph the right way up

As expected, this has now show up another issue.

If you look at the attached, when you have a particular month and location selected, the graph works 100% perfectly.

In that, the two reference lines are working.

However, once you remove these filters, you'll see the two reference lines don't sync.

We don't have a simple case of amount per customer anymore; we have duplicate values per customer, due to the month and location fields being different.

This is where i was having problems with the count distinct.

Any advice?

Much appreciated

sunny_talwar

Check for max using this on the presentation tab

=num(Sum(Aggr(If(Sum(Amount) > 0, Sum(Amount)), [Customer Name])),'#,##0')


Capture.PNG

marcus_steggall
Creator
Creator
Author

awesome, that's worked like a treat

Many thanks

sunny_talwar

Awesome, I am glad it worked