Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
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.
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: