topic Re: Multiple chart in a single tab in QlikView

Multiple chart in a single tab

Anonymous — Tue, 03 May 2016 21:51:54 GMT

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

Re: Multiple chart in a single tab

Nicole-Smith — Tue, 03 May 2016 22:11:38 GMT

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

Re: Multiple chart in a single tab

phaneendra_kunc — Tue, 03 May 2016 22:14:44 GMT

Perhaps something like in attached?

You can use "Trellis" in Dimensions tab.

Re: Multiple chart in a single tab

moleroalonso — Tue, 03 May 2016 22:15:08 GMT

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.

Re: Multiple chart in a single tab

Anonymous — Tue, 03 May 2016 22:27:32 GMT

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.

Re: Multiple chart in a single tab

Anonymous — Tue, 03 May 2016 23:03:19 GMT

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

Re: Multiple chart in a single tab

marcus_sommer — Wed, 04 May 2016 06:00:02 GMT

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

Re: Multiple chart in a single tab

Wed, 04 May 2016 08:53:13 GMT

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

Re: Multiple chart in a single tab

Anonymous — Wed, 04 May 2016 15:14:25 GMT

Thank you all!

This works. I learn something today.