Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rank() function question

Hi all,

This is my issue:

I Have an "Exception" table with the following dimensions : App, Advertiser and Campaign ID.

I would like to add as an expression the "Main Partner", meaning the partner who has the largest value of revenue.

I'm using the following expression:

2014-07-22_15-41-11.pngbut in the result, I see only "-".

Can you help?>

Thank you!

Ella

9 Replies
richard
Partner - Creator
Partner - Creator

Looks like you're missing the $ after "sum(..."

tresesco
MVP
MVP

Remove the outer If and include the condition in the set analysis part like:

=If(Rank(Sum({<Exception type={'Positive 1 STD Exception'}, isYesterdayDate= .....

MK_QSL
MVP
MVP

=IF(Aggr(Rank(SUM({<IsYesterdayDate = {1},PartnerReport = {'PartnerReport'}, [Exception Type] = {'Positive 1 STD Exception'}>}(ClickCost + InstallCost))/100),partner_name)<2, partner_name)

Not applicable
Author

Hi All,

The sum should not include the "[Exception Type]" part.

It is a calculated expression in that table, and I would like to get the "Partner" field to appear only if the Exception type equals to what is written above.

In any case, why would an "if" inside of an "if" create problems?

tresesco
MVP
MVP

Could you post your app with sample data?

Not applicable
Author

Please post sample qvw with data & reproduce the issue.

Not applicable
Author

Hi All,

As Thank you for your answers..

Please see the QVW here: https://drive.google.com/file/d/0B4dVjL8rcPOCb0tmOVFrUTVMX00/edit?usp=sharing

I am trying to get a value under "Campaign STD Limited" tab, under "1 std Positive exception" table, and under "Main Partner column".

Can you please advise?

Thank you!

Ella

Not applicable
Author

Please see mt QVW at the bottom

Not applicable
Author

Please see mt QVW at the bottom