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