topic Re: Total Sales for each Year in QlikView

Total Sales for each Year

Sat, 09 Jan 2016 13:28:40 GMT

Hello!

I am trying to get row number for total orders for each year inside a Straight table.

I am using the expression: =COUNT({<Year={$(=(Max(Year)))}>} OrderID) to what I believe should show the amount of orders(row-wise) for that year. I use that same expression but with -1, -2 etc. to get the previous year until the years in the excel-file has ended. But when I show this in the table, I get the same value on every expression. It is as if all I get is how many orders that exist in the file, and does not modify which year it should show how many orders there is.

I recieve the same error in my tables when I try to show total sales for every year, =SUM({<Year={$(=(Max(Year)))}>} Sales) is the expression for that.

If anyone here realize my problem, kindly advise on how to right this wrong.

If you need more info, please tell me and I will gladly give it.

Re: Total Sales for each Year

sunny_talwar — Sat, 09 Jan 2016 13:51:25 GMT

What do you see when you put =Max(Year) in a text box object?

Re: Total Sales for each Year

swuehl — Sat, 09 Jan 2016 13:57:10 GMT

It would be easier to help you if you could upload a small sample QVW that demonstrates your issue.

Some possible issues to check:

- Year field is not numeric, hence max() does not work (try a text box with =max(Year) )

- Year field shows a different textual representation than its numeric value (compare max(Year) with e.g. Year list box values)

- Year field is not connected to OrderID in the data model (does the count(OrderID) change when you select in field Year?)

Re: Total Sales for each Year

Sat, 09 Jan 2016 15:02:45 GMT

I get 2010. Which is correct

Re: Total Sales for each Year

Sat, 09 Jan 2016 15:36:29 GMT

I think I know what was at fault here. The data in my excel-files are somewhat weird, I one summary report which is over year 2005 to 2010, and one sales file where the sales has been done in the year 2005 - 2008. When I switched years I got the correct values.

Thanks for the help anyways!

Re: Total Sales for each Year

sunny_talwar — Sun, 10 Jan 2016 16:03:56 GMT

Great, I am glad you were able to figure it out.

Please close the thread by marking your answer as correct and any helpful answers.

Best,

Sunny