Multiple chart in a single tab

[Anonymous]

I have a table that has a various values (let's say the name of the filed is product) and that field has 8 names of product.

Let's assume the table has two columns; A and B where A is product name and column B is the sales value

I'd like to create multiple charts using expression for each product, so each chart for each product.  Is there a way to create multiple charts for each product in the same tab instead of selecting manager's name in the Table field one by one to change the chart?

So basically each chart is linked to each product.

I am new to Qlikview so any hint will help.

Thanks

[Nicole-Smith]

A Trellis chart may be what you're looking for: Getting the most out of a Trellis bar chart, some tricks

[phaneendra_kunc]

Perhaps something like in attached?

You can use "Trellis" in Dimensions tab.

[moleroalonso · Accepted solution]

You need to useSET ANALYSIS in your expressions.

For example, In order to create a graph for a product called "Product A" you have to create a graph with the dimension "A" and an expresion like this: Sum({<A={"Product A"}>} SaleValues) . The text text in bold is the set analysis.

[Anonymous]

Unfortunately, not Trellis chart that I am looking for as it is too small to show and I'd like to adjust scale for each chart since each chart has big difference in values. Not sure if Trellis can do this?

I am showing bar or line charts for each.

[Anonymous]

I am using Personal edition. Phaneendra, is it possible to explain?

[marcus_sommer]

You could simply copy your barchart 8-times and adjust the expression like in the suggestion from moleroalonso. Possible would also be a more generic solution like:  Sum({<A={"$(=Fieldvalue('A', 1))"}>} SaleValues).

- Marcus

[#8]

hi ahmad fikri I think this file  might help you sice i have used mutiple chart in a single tab

[Anonymous]

Thank you all! 

This works. I learn something today.