Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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.  

View solution in original post