Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
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

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