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: 
Not applicable

Type of chart

Hi all,

Is this type of chart possible? Blue is Product 'A' sales and Green Product 'B' sales, whereas Grey is total sales.

chart.png

BR,

SAK

14 Replies
sundarakumar
Specialist II
Specialist II

4444.PNG.png

1.PNG.png

222.PNG.png333.PNG.png

5555.PNG.png

Not applicable
Author

Great! Achieved after making bar distance Zero in Presentation tab.

One more thing!  In expression tab, if i check 'values on data points' in first sum(sales) expression, it's giving correct. But if I check the same for 2nd TOTAL expression, it's giving three totals, though i need one. for example, in Jan month, I need 620 on top of gray bar.

Thanks a lot! dear.

BR,

SAK

Not applicable
Author

Yahoo! done.Sundarakumar Kalaimani

I used Combo chart. First two expressions with bar. third expression with symbol (plus) with formula SUM(TOTAL<Month>Sales).

But if you have one product selected in the list, the lining up of two 'Values on Data points' was not good as pointed by Steve Dark.

However, to avoid lining up issue I made third expression conditional as =GetSelectedCount(Product)=0 or GetSelectedCount(Product)>1.

In the end, it all worked great.

Thanks a lot!

Not applicable
Author

In presentation tab, unchecked pop-up labels, as really there is no need for it as everything is labelled itself - month, product name, each product monthly sale, and total monthly sale; otherwise natural pop up does not look proper (especially for 2nd expression).

sundarakumar
Specialist II
Specialist II

You are welcome