Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Tags (1)
9 Replies
richard
Contributor

Re: Rank() function question

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

MVP
MVP

Re: Rank() function question

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

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

Re: Rank() function question

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

Not applicable

Re: Rank() function question

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?

MVP
MVP

Re: Rank() function question

Could you post your app with sample data?

Not applicable

Re: Rank() function question

Please post sample qvw with data & reproduce the issue.

Not applicable

Re: Rank() function question

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

Highlighted
Not applicable

Re: Rank() function question

Please see mt QVW at the bottom

Not applicable

Re: Rank() function question

Please see mt QVW at the bottom

Community Browser