topic Re: Chart show Values for only one segment on top of data points in QlikView

Chart show Values for only one segment on top of data points

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

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

Re: Chart show Values for only one segment on top of data points

Anil_Babu_Samineni — Fri, 20 Jan 2017 09:47:03 GMT

Try to disable the First expression and then see or you may share to solve with you dummy application

Re: Chart show Values for only one segment on top of data points

khigaurav999 — Fri, 20 Jan 2017 10:05:58 GMT

Hi Anil,

Disabling the First expression doesn't fix the issue. How can I share it? I cannot share QVW due to data.

Thanks,

Gaurav

Re: Chart show Values for only one segment on top of data points

Anil_Babu_Samineni — Fri, 20 Jan 2017 10:08:55 GMT

NP, Don't share original data create dummy data and then share with us. We can give number of options unfortunately those are not make sense. If you send the application then it would better for one luck

Scrambling Data

Re: Chart show Values for only one segment on top of data points

sunny_talwar — Fri, 20 Jan 2017 10:33:44 GMT

When I use this

Num(Sum([TOV]/1000), '$#,##0.00K / ') & (Num(Sum([FUNDED_HRS]), '##. hrs'))

I got this

Re: Chart show Values for only one segment on top of data points

khigaurav999 — Fri, 20 Jan 2017 10:45:47 GMT

Attaching application will not be possible since it will require a significant effort in scrambling. is they any other option you think can help? I can share scheenshots of chart properties.

Thanks,

Gaurav

Re: Chart show Values for only one segment on top of data points

khigaurav999 — Fri, 20 Jan 2017 10:51:24 GMT

Thanks, Sunny. I tried this expression i.e. converting it in Num but it doesn't work. Can you show this (sum of these two i.e. $128.72K / 137 hrs ) on top of bar and attach your file.

Try to uncheck "Plot Values Inside Segment" under Presentation property to show it on top of the bar. I am also wondering if there is any option in properties that I need to enable or disable to fix.

Thanks,

Gaurav

Re: Chart show Values for only one segment on top of data points

khigaurav999 — Fri, 20 Jan 2017 11:07:48 GMT

I tried doing it in your example... same issue exists. It shows value for only one cell

Re: Chart show Values for only one segment on top of data points

khigaurav999 — Fri, 20 Jan 2017 11:47:12 GMT

I attached an example file below. Please check it out.

Re: Chart show Values for only one segment on top of data points

sunny_talwar — Fri, 20 Jan 2017 11:51:16 GMT

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'))

Re: Chart show Values for only one segment on top of data points

sunny_talwar — Fri, 20 Jan 2017 11:51:18 GMT

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'))