Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

Dynamic reference line

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,,

4 Replies
avkeep01
Partner
Partner

Have you tried

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

Anil_Babu_Samineni

Currently what is the status?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
nareshthavidishetty
Creator III
Creator III
Author

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

Anil_Babu_Samineni

Hahaha, That is your data. You should test

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)