Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Summing amounts/revenues by month

I am a new Qlikview user, and am working on my first qvw.  I have a dataset from excel with headers such as: Provider, Customer, Svc Month, amount etc.  I want to display the total "amount" by "Provider" for each of my service months.  How do I write the correct expression to sum my "amounts" for each of the months I  have listed?

3 Replies

I would suggest creating a chart (a straight table chart to start with, or a pivot table chart or line or bar chart) with two dimensions Svc Month and Provider and one expression


Not applicable

Hope this helps... just play around with options.


The Video Library on the New to QlikView page will likely helpful to you.  Create a Chart Object will specifically answer this question.

You may also want to register for the weekly webinar "Getting Started with QlikView Personal Edition"

QlikView Events - Business Intelligence (BI) Reporting Software Solutions | QlikView