Need to show last 6

[bharatkishore]

Hi All,

I am having an dimension called Email_Subjectline.. and i have given expression as

=if(rank(((SUM([Unique Opens])/sum([Total Sends]-[Total Bouncebacks]))

-

Avg(TOTAL {<Campaign = {"=Rank(SUM([Unique Opens])/sum([Total Sends]-[Total Bouncebacks])) <= 6"}>} Aggr(Sum([Unique Opens])/sum([Total Sends]-[Total Bouncebacks]), Campaign)))/

Avg(TOTAL {<Campaign = {"=Rank(SUM([Unique Opens])/sum([Total Sends]-[Total Bouncebacks])) <= 6"}>} Aggr(Sum([Unique Opens])/sum([Total Sends]-[Total Bouncebacks]), Campaign)))

<=3,'qmem://<bundled>/BuiltIn/led_g.png','qmem://<bundled>/BuiltIn/led_y.png')

Now i need show last 6 records based on EmailSentDate..

If i show dimension limits as largest 10 it is not working..Pls Suggest

[Gysbert_Wassenaar]

Please post a small qlikview document that demonstrates the problem.

[bharatkishore]

Hi,

Pls find the attached qvw and excel

[Gysbert_Wassenaar]

Dimension limits use the first expression of the chart. If you want a top N by any other expression then you need to move that expression to the top of the expressions lists.

[bharatkishore]

I need to be stable to all the expressions.. Dimension limits is working correctly for the first expression but it is not working for the other expressions.

Kindly suggest..

[Gysbert_Wassenaar]

Can you explain 'not working'? As I said, only the values of the first expression are used to determine which combination of dimension values are shown as the Top N.

[bharatkishore]

How can i show top 6 for the other expressions..Is it possible without using dimension limits?

[Gysbert_Wassenaar]

You could use different charts. Or use an expression group to let users switch between the expressions.