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
Contributor

Combo chart to show total gross sales and product wise sales

Hi,

I have a requirement to show the chart as Attached. Here Total sales is constant irrespective of the selection of Product, But when i select Product that slaes should be shown in line across the bar chart. I am choosing Combo chart with 2 exprssions

Dimensions: Qtr

1expr: used set analysis to fix the product selection for sum(sales)

2Expr:  sum(sales). it will be change based on selection of product field.

But when i select more than 2 product, it is showing sum of these product sales. but i need to show individual lines for each product.

If i get it by overlapping chart, X and Y axis values are changing automatically. so i could not fix it.

Added sample data also

Please help me on this.

1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: Combo chart to show total gross sales and product wise sales

Hi plz look into attached app, if it is which you need then sounds gr8

View solution in original post

6 Replies
Highlighted

Re: Combo chart to show total gross sales and product wise sales

Would you be able to share a sample to play around with this?

Highlighted
Not applicable

Re: Combo chart to show total gross sales and product wise sales

Can you share your sample data, so that it could help us to give solutions

Highlighted
Not applicable

Re: Combo chart to show total gross sales and product wise sales

Hi plz look into attached app, if it is which you need then sounds gr8

View solution in original post

Highlighted
Contributor

Re: Combo chart to show total gross sales and product wise sales

Hi, I didn't see any Attachment.

Highlighted
Honored Contributor III

Re: Combo chart to show total gross sales and product wise sales

Open and read the actual topic. It clearly is there.

May you live in interesting times!
Highlighted
Contributor

Re: Combo chart to show total gross sales and product wise sales

Actually i have 3 fields

1.year-qtr

2.product

3.sales

now i want to show total sales on bar's irrespective of product selection

and show the lines as sales of products that are selected.

so i have used below dementions and expressions are

Dimention: year-qtr

Expression:

1) sum({<product=>sales}

2) Sum(sales)

so 1st expression shows total sales in bar's. The 2nd expression shows sales based on selection of product. but if i select 2 products then it is showing as sum of these product sales.

but i want to show different lines for each product.

I tried it by using overlapping charts one for bar and another for lines. but Y-axis values are changing .so please provide the solution to this.