topic Re: Rank() function question in QlikView

Rank() function question

Tue, 22 Jul 2014 12:45:12 GMT

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:

but in the result, I see only "-".

Can you help?>

Thank you!

Ella

Re: Rank() function question

richard — Tue, 22 Jul 2014 12:51:33 GMT

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

Re: Rank() function question

tresB — Tue, 22 Jul 2014 12:52:02 GMT

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

MK_QSL — Tue, 22 Jul 2014 12:52:38 GMT

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

Re: Rank() function question

Tue, 22 Jul 2014 13:05:01 GMT

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?

Re: Rank() function question

tresB — Tue, 22 Jul 2014 13:07:25 GMT

Could you post your app with sample data?

Re: Rank() function question

Tue, 22 Jul 2014 17:53:36 GMT

Please post sample qvw with data & reproduce the issue.

Re: Rank() function question

Mon, 28 Jul 2014 13:43:57 GMT

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

Re: Rank() function question

Tue, 29 Jul 2014 14:21:52 GMT

Please see mt QVW at the bottom

Re: Rank() function question

Tue, 29 Jul 2014 14:22:44 GMT

Please see mt QVW at the bottom