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

[vinieme12]

Refer this post on showing custom values in chart

Partial Sums in straight table | Custom Labels in Pivot SubTotals

for  a sample try below

Load * inline [

Category,Sales

Val1,1

Val2,2

Val3,3

Val4,4

];

LOAD Rowno() as DIM

AutoGenerate(2);

Front End:

Chart Dimension

=Pick(DIM,'TestValue',Category)

Chart Expression

Pick(DIM,'TestValue',sum(Sales))

[#3]

Sorry,It is not working for me

[vinieme12]

please post your app

[#5]

Vendor	Value
a	50
b	40
c	30
d	60
e	70
f	80
g	90
h	35
i	75

I have values like this in different sheets, i am calculating top vendors based on sum(Value).

I am using calculated dimension for vendor something like if(Aggr(Rank(sum(Value)), Vendor) <6, Vendor) It is giving me top 5 vendors. However, i need to show particular vendor in the first row irrespective of the rank as priority, In the above example , Vendor "h" should be shown in the first row and followed by remaining top 4 vendors ,

[vinieme12]

Try below calculated dimension

=Pick(DIM,'h'

,AGGR(only({<Vendor={"=rank(Value)<=4"}>}Vendor),Vendor))

and expression

Pick(DIM,sum(Value),Rank(Sum(Value)))

generate dimension DIM in load script as below

load rowno() as DIM

AutoGenerate(2);

[vinieme12]

See attached sample app

[vinieme12 · Accepted solution]

See attached sample app

[#9]

Hi Vineeth,

Thanks for the help,the logic u mentioned working correctly for the vendor and rank columns.

I also have SUm(Value) as next expression,when I add new logic into my chart properties.For SUm(Value) expression getting different values.

Once again thanks a lot for your help

[vinieme12]

You will have to repeat the format for adding expressions with Pick()

example

Pick(DIM , Expression2, expression2)

Pick(DIM , Expression3, expression3)