Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
A Trellis chart may be what you're looking for: Getting the most out of a Trellis bar chart, some tricks
Perhaps something like in attached?
You can use "Trellis" in Dimensions tab.
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.
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.
I am using Personal edition. Phaneendra, is it possible to explain?
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
hi ahmad fikri I think this file might help you sice i have used mutiple chart in a single tab
Thank you all!
This works. I learn something today.