Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Re: Show two values on one bar chart

Or this

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


Capture.PNG

View solution in original post

8 Replies
Highlighted

Re: Show two values on one bar chart

Use this for No of Visits expression

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


Capture.PNG

Highlighted

Re: Show two values on one bar chart

Or this

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


Capture.PNG

View solution in original post

Highlighted
Creator II
Creator II

Re: Show two values on one bar chart

Nice work! Thanks

Highlighted
Creator II
Creator II

Re: Show two values on one bar chart

Hi Sunny,

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

Thanks

Highlighted

Re: Show two values on one bar chart

What values do you expect to see for FTF?

Highlighted
Creator II
Creator II

Re: Show two values on one bar chart

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

Highlighted

Re: Show two values on one bar chart

Check the attached

Capture.PNG

Highlighted
Creator II
Creator II

Re: Show two values on one bar chart

Thanks Sunny! Excellent work!