topic Re: Formatting my data, or the Script Editor in QlikView

Formatting my data, or the Script Editor

Fri, 22 Nov 2013 21:56:40 GMT

My data set consists of lines of rows of transaction data. Some of the headers include transaction date, posted date, charge amt, customer, and salesman.

I want to display on a bar chart the sales volume by month for each salesman. When I load my data and create my bar chart, I get each individual sales amounts along the X axis, and the count for each sales amount along the Y axis.

How do I edit the script so that it sums the total amount for each salesman so it can be displayed on the graph?

Re: Formatting my data, or the Script Editor

Anonymous — Sat, 23 Nov 2013 18:52:02 GMT

Jon

It is hard to guess what your issue is without seeing a sample qvw, would you be able share one ?

If your sample qvw did an Inline Load of your sample data, then great as it may need the load script tweaking.

Best Regards, Bill

Re: Formatting my data, or the Script Editor

Anonymous — Mon, 25 Nov 2013 12:02:24 GMT

Hi,

I think you have to make a dimension with the salesman in you chart and nothing else. So no need to change your script.

The chart will calculate the sum of all selected sales amounts per dimension (salesman) for you if you mention sum in the expression.

Paul

Re: Formatting my data, or the Script Editor

salto — Mon, 25 Nov 2013 12:12:48 GMT

Yes, I would not change anything in the script. You have all the dimensions and the only thing you need to do is use the salesman as a dimension in the chart.

Re: Formatting my data, or the Script Editor

Josh_Good — Mon, 25 Nov 2013 19:50:01 GMT

In the chart you need to tell QlikView to sum the sales (e.g. use the function Sum(Sales). Then just add the dimensions Salesperson and Month. Note if you don't have Months in your source data then QlikView can create it at time of load. Check out the attached QVW for an example.

You may also want to check out these resources:

New to QlikView Videos

Re: Creating A Master Calendar