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: 
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.