Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ivandrago
Creator II
Creator II

Show two values on one bar chart

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

1 Solution

Accepted Solutions
sunny_talwar

Or this

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


Capture.PNG

View solution in original post

8 Replies
sunny_talwar

Use this for No of Visits expression

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


Capture.PNG

sunny_talwar

Or this

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


Capture.PNG

ivandrago
Creator II
Creator II
Author

Nice work! Thanks

ivandrago
Creator II
Creator II
Author

Hi Sunny,

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

Thanks

sunny_talwar

What values do you expect to see for FTF?

ivandrago
Creator II
Creator II
Author

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

sunny_talwar

Check the attached

Capture.PNG

ivandrago
Creator II
Creator II
Author

Thanks Sunny! Excellent work!