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.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
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
MVP
MVP

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

=sum(amount)

Not applicable

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

Employee
Employee

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