topic Re: Problem with creating a graphic in QlikView

Problem with creating a graphic

Tue, 29 Sep 2015 12:45:13 GMT

What's up guys!

So, I'm having some trouble creating a chart that my director wants.

Actually, I don't know if what he wants is possible to do on Qlikview.

I need to create a chart that shows in bars the amount produced of one product per month and in a line the amount produced of all products of some client, but I need it to be multicolored and that the products show in the legend. The way I'm doing only the expression are being shown in the legend.

In the attachment there's a document to help you understanding the problem!

Thank you all since now.

Re: Problem with creating a graphic

settu_periasamy — Wed, 30 Sep 2015 02:09:11 GMT

Hi,

Try the below steps.

1. Remove the Product field from Dimension. (Now, the Month is the only field should be in Dimension)

2. You need to create 3 expressions

One for Product 1 (Bar) - Use Sum with set Analysis

Second for Product 2 (Bar) - Sum with Set Analysis

Third should be Sum of Total Product (Line)

if it is not working, Post the sample data.

Re: Problem with creating a graphic

Wed, 30 Sep 2015 10:42:38 GMT

Thanks for your concerning, settu_periasamy, but my problem is that I don't have only the two products...

Products may vary, they come from another table. It can't be permanent.

As you could see, I have the breaks set to Month and product. My expressions are:

Line of total produced of all products: Aggr(Sum({$<PRODUCT=>} AMOUNT),MONTH)

Bars of total of each product selected: Sum(AMOUNT)

If it's not clear enough let me know.

Thanks!