topic Re: Show two values on one bar chart in QlikView

Show two values on one bar chart

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

Hi,

I have the attached Document which shows a a stacked bar chart using the chart wizard and another chart underneath showing the chart I wish to have but not sure it is possible.

Basically I want two values to be on the one bar chart, so the sum of VisitCount will always be higher than the the set analysis expression of FTF, if both values are the same then I would like the values to be the sum of the VisitCount and the bar to show as blue.

I hope I've explained myself clearly but you can see from the attached document the difference of where the total value of the single bar is different.

Thanks

Re: Show two values on one bar chart

sunny_talwar — Tue, 02 Jan 2018 20:56:20 GMT

Use this for No of Visits expression

sum(VisitCount)-sum( {$<FTF={1}>} VisitCount)

Re: Show two values on one bar chart

sunny_talwar — Tue, 02 Jan 2018 22:12:44 GMT

Or this

Dual(Sum(VisitCount), Sum(VisitCount)-sum( {$<FTF={1}>} VisitCount))

Re: Show two values on one bar chart

ivandrago — Tue, 02 Jan 2018 22:51:44 GMT

Nice work! Thanks

Re: Show two values on one bar chart

ivandrago — Tue, 02 Jan 2018 23:45:36 GMT

Hi Sunny,

How would I change this so the FTF shows a percentage instead of a value?

Thanks

Re: Show two values on one bar chart

sunny_talwar — Wed, 03 Jan 2018 01:36:15 GMT

What values do you expect to see for FTF?

Re: Show two values on one bar chart

ivandrago — Wed, 03 Jan 2018 09:40:02 GMT

Hi Sunny,

So you can take "Values on Data Points" off and I would expect to see the below percentages for FTF:

Phil King - 28.57%

John Smith - 50.00%

Steve Jones - 20.00%

Barry Smith - 0.00%

Tom Jones - 100.00%

Thanks

Re: Show two values on one bar chart

sunny_talwar — Wed, 03 Jan 2018 09:44:23 GMT

Check the attached

Re: Show two values on one bar chart

ivandrago — Wed, 03 Jan 2018 13:58:21 GMT

Thanks Sunny! Excellent work!