URGENT:specifying dimension value in first row irrespective of the condition in qlikview table

[#1]

Hi,

I have requirement where I need to add one dimension value to the first row of the table irrespective of the condition.

Here I am using rank condition for getting top 5 values say Val1,Val2,Val3,Val4,Val5 for particular dimension. i need to show one dimension value like TestValue in the first row irrespective of its rank and then followed by top 5 values

Dimension1	Rank
TestValue	Rank(TestValue)
Val1	1
Val2	2
Val3	3
Val4	4
Val5	5

[#2]

Hi Vineeth,

I tried to use the logic but I am getting wrong results. As per the logic,when h value is not in top 5,it should show h+top4. However I am getting "h+ top5".When h value is within top5,it is showing correctly.

I cannot attach the example as I am seeing this difference for some filter selctions

[vinieme12]

However I am getting "h+ top5".

It will be because the values of the top 5 may be same

for example  if you have values like

10,20,25,30,30,40,8,9,7

Here Top 3  ie Rank()<= 3  is 10,20,25

but if you do top 4 then Rank() will give back  5 values  ie 10,20,25,30,30

[vinieme12]

Rank ‒ QlikView