Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear friends and community members,
I am concating values / results from two aggr. functions and trying to display customized result (in a specific format) on top of bar as values on data points but it is showing values for only one segment (largest segment) rather than showing the consolidated sum of all the segment.
For example: when i just do simple sum([TOV]), it shows correctly i.e. 128.72 = 84.92 + 43.80
But when i do it with expression '$' & (Sum([TOV])/1000) &'K / '& (sum([FUNDED_HRS])) & 'hrs' like mentioned above in the thread, it shows value for only one segement i.e. 84.92 . deosn't include the value of yellow segment in this case. any idea ?
More details on my issue can be found on this question which has been marked as answered and I was advised to put a separate question for this issue!. https://community.qlik.com/message/1196368?et=watches.email.thread#1196368
Thank you in advance for your kind help.
Gaurav
You just want the total at the top? May be this
Num(Sum(TOTAL <MonthYear> [TOV]/1000), '$#,##0.00K / ') & (Num(Sum(TOTAL <MonthYear> [FUNDED_HRS]), '##. hrs'))