Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

   

Dimension1Rank
TestValueRank(TestValue)
Val11
Val22
Val33
Val44
Val55
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

See attached sample app

1331734.PNG

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

22 Replies
vinieme12
Champion III
Champion III

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))

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable
Author

Sorry,It is not working for me

vinieme12
Champion III
Champion III

please post your app

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable
Author

   

VendorValue
a50
b40
c30
d60
e70
f80
g90
h35
i75

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
Champion III
Champion III

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);

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

See attached sample app

1331734.PNG

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

See attached sample app

1331734.PNG

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable
Author

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
Champion III
Champion III

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

example

Pick(DIM , Expression2, expression2)

Pick(DIM , Expression3, expression3)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.