topic Re: Display calculated dimension in Chart title in QlikView

Display calculated dimension in Chart title

johnb023 — Thu, 18 Mar 2021 18:10:53 GMT

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

PradeepK — Thu, 18 Mar 2021 18:36:24 GMT

Concat( distinct {<H_Process= {"=Rank(sum(Cost))=2 "}>} H_Process )

johnb023 — Thu, 18 Mar 2021 18:54:46 GMT

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.