topic Re: Dynamic reference line in QlikView

Dynamic reference line

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

We need to create a dynamic reference line to the line chart.

Expression used : =IF(isnull(num(sum([Open]),'#,##0')), Null(), Num( num(sum({$<[30+ Days]={1}>} [Open]),'#,##0') / num(sum([Open]),'#,##0'),'#,###0.0%'))

Based on the selection the chart reference line should reflect dynamically.

Thanks,,

Re: Dynamic reference line

avkeep01 — Thu, 31 May 2018 07:19:27 GMT

Have you tried

Num(IF(sum([Open])>0, sum({$<[30+ Days]={1}>} [Open]) / sum([Open]),'#,###0.0%'))

Re: Dynamic reference line

Anil_Babu_Samineni — Thu, 31 May 2018 08:42:00 GMT

Currently what is the status?

Re: Dynamic reference line

nareshthavidishetty — Thu, 31 May 2018 10:26:51 GMT

Hi,

I'm getting a reference line.

But doubt is reference line is the average of results right. But we have used the direct expression results.

Is it correct?If not please share the right one .

Thanks..

Re: Dynamic reference line

Anil_Babu_Samineni — Thu, 31 May 2018 10:45:17 GMT

Hahaha, That is your data. You should test