Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
fikristar
Contributor

Multiple chart in a single tab

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

Tags (1)
1 Solution

Accepted Solutions
moleroalonso
New Contributor II

Re: Multiple chart in a single 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.

8 Replies

Re: Multiple chart in a single tab

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

phaneendra_kunc
Valued Contributor III

Re: Multiple chart in a single tab

Perhaps something like in attached?

You can use "Trellis" in Dimensions tab.

moleroalonso
New Contributor II

Re: Multiple chart in a single 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.

fikristar
Contributor

Re: Multiple chart in a single tab

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.

fikristar
Contributor

Re: Multiple chart in a single tab

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

Re: Multiple chart in a single tab

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

Not applicable

Re: Multiple chart in a single tab

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

fikristar
Contributor

Re: Multiple chart in a single tab

Thank you all! 

This works. I learn something today.

Community Browser