Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.