Rank

[#1]

Hi All

Below is the calculations which i want to achieve in script

these calculated dimensions are working correctly but i need that in load script

please suggest

Weekly_Rank	=aggr(rank(sum({<Flag={"Weekly"}>}delta)),ID,Flag,delta)
Monthly_Rank	=aggr(rank(sum({<Flag={"Monthly"}>}delta)),ID,Flag,delta)
Live_Rank	=aggr(rank(sum({<Flag={"Live"}>}delta)),ID,Flag,delta)

[sunny_talwar]

Are you using another script or the same exact script as in your sample?

[#3]

Sunny

I am using the same exact script as in the bok2.qvw

the actual problem is in the below screen shot

for monthly_rank 1 two dates are showing there should be only one date

[sunny_talwar]

Can you post a snapshot of the issue you are having? I am struggling to understand the issue.

[#5]

Hi Sunny

this value in field a 120273012|monthly|20160930 should have a different Monthly_rank

i want the Monthly_rank to be grouped by  month end dates

and the weekly_rank to be grouped by weekly dates

[sunny_talwar]

But isn't this issue resolved in Book2_v1?

[#7]

Hi Sunny

in Book2_v1

if Monthy_Rank 1 and 2  Selected, same values repeating

[Anonymous]

The values have to repeat--there are two different IDs for Date = 20161130.

Where are you getting Weekly_Rank, Monthly_Rank, and Live_Rank from? Your Peek() function looks for them in the Fact table loaded from your Excel workbook, but the Excel workbook has no such fields. I think you mean to use "B" in the Peek() function, right?