Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
johnb023
Contributor III
Contributor III

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 III
Contributor III
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 III
Contributor III
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.