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: 
sateeshkumar
Creator
Creator

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

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

View solution in original post

6 Replies
sunny_talwar

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

Not applicable

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

Not applicable

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

sateeshkumar
Creator
Creator
Author

Hi, I didn't see any Attachment.

oknotsen
Master III
Master III

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

May you live in interesting times!
sateeshkumar
Creator
Creator
Author

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.