Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Valued Contributor II

Re: Type of chart

Highlighted
Not applicable

Re: Type of chart

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

Highlighted
Not applicable

Re: Type of chart

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!

Highlighted
Not applicable

Re: Type of chart

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

Highlighted
Valued Contributor II

Re: Type of chart

You are welcome