Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
johnb023
Contributor II
Contributor II

Display calculated dimension in Chart title

I have a chart dimension that returns just 1 value - by design.

=if(aggr(rank(sum(Cost),4),H_Process) = 2, H_Process)

How can I display the value/output of this expression in the chart title?

 

Thanks

Labels (2)
1 Solution

Accepted Solutions
johnb023
Contributor II
Contributor II
Author

Thank you for the help.  I didn't know where to start. 

I found

Concat(
distinct
{<H_Process= {"=aggr(rank(sum(Cost),4),H_Process) = 2"}>}
H_Process
)

did the trick.  

View solution in original post

2 Replies
PradeepK
Creator II
Creator II

Concat(
	distinct 
    {<H_Process= {"=Rank(sum(Cost))=2 "}>} 
    H_Process
)
johnb023
Contributor II
Contributor II
Author

Thank you for the help.  I didn't know where to start. 

I found

Concat(
distinct
{<H_Process= {"=aggr(rank(sum(Cost),4),H_Process) = 2"}>}
H_Process
)

did the trick.