Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
gowrishankarangrybird
Contributor II
Contributor II

How to add extra text in line Chart

gowrishankarangrybird_0-1663748127654.png

 How to show  text in near by this Value ?

I used Expression 

 

Complete : RangeSum(Above( ( Count({<OnTimeStatus={'True'}>}distinct [Release Name]) ) , 0, RowNo()))/RangeSum(Above( ( Count(distinct [Release Name]) ) , 0, RowNo()))

 

& Total Count : RangeSum(Above( ( Count({<OnTimeStatus={'True'}>}distinct [Release Name]) ) , 0, RowNo()))

gowrishankarangrybird_0-1663926417421.png

Example : 

Total Count :80 & Complete: 100%

Thanks in Advance

@sunny_talwar 

Labels (1)
1 Solution

Accepted Solutions
gowrishankarangrybird
Contributor II
Contributor II
Author

I used Expression 

 

Percentage : RangeSum(Above( ( Count({<OnTimeStatus={'True'}>}distinct [Release Name]) ) , 0, RowNo()))/RangeSum(Above( ( Count(distinct [Release Name]) ) , 0, RowNo()))

 

& Total Count : RangeSum(Above( ( Count({<OnTimeStatus={'True'}>}distinct [Release Name]) ) , 0, RowNo()))

gowrishankarangrybird_0-1663926417421.png

 

View solution in original post

3 Replies
SerhanKaraer
Creator III
Creator III

Hi,

For a sample model table like this:

LOAD * INLINE [
record, count, percentage
1, 80, 100
2, 90, 100
3, 45, 80
];

You can use "record" as dimension, and aggr(Dual('Total Count: ' & sum(count) & ' & Complete: ' & Sum(percentage),Sum(percentage)),record) as your measure. After that, you must change number formatting as measure expression.

SerhanKaraer_0-1663927210936.png

 

Then, you achive a chart like this:

SerhanKaraer_0-1663782217474.png

 

gowrishankarangrybird
Contributor II
Contributor II
Author

I used Expression 

 

Percentage : RangeSum(Above( ( Count({<OnTimeStatus={'True'}>}distinct [Release Name]) ) , 0, RowNo()))/RangeSum(Above( ( Count(distinct [Release Name]) ) , 0, RowNo()))

 

& Total Count : RangeSum(Above( ( Count({<OnTimeStatus={'True'}>}distinct [Release Name]) ) , 0, RowNo()))

gowrishankarangrybird_0-1663926417421.png

 

SerhanKaraer
Creator III
Creator III

Sorry, I had forgotten to add change of number formatting in measure settings. I added number formatting in original reply post.