topic Re: calculate the sales in QlikView

calculate the sales

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

HI Experts,

I have one year list box in that i am having data like 2010 to 2016 and respected sales

If click on 2013year then i want see the total sales for 2013 ,2012,2011 and 2010.

How to calculate the total based on the selection?

sunny_talwar — Tue, 26 Jun 2018 11:12:00 GMT

So, sales for all years on and before the selected year? May be this...

Sum({<Year = {"$(='<=' & Max(Year))"}>}Sales)

Anonymous — Tue, 26 Jun 2018 11:43:56 GMT

HI Thanks for the reply,

The above expression is correct but at the same time it is calculating the all months from all years right?

But if i click on 2013 year and 4 th month then how to calculate ?

sunny_talwar — Tue, 26 Jun 2018 11:45:30 GMT

What should happen when you select the 4th month? You want to see the sum of sales of 4th month for 2013, 2012, 2011... etc?

Anonymous — Tue, 26 Jun 2018 12:00:29 GMT

When we select "2013" and month "04" we would see 2010 - 2013 (correct!) but only for month 04

i want to see 2010 - 2012 month 1-12 and 2013 month 1 - 4.

sunny_talwar — Tue, 26 Jun 2018 12:11:25 GMT

May be create a monthcounter in the script for Master Calendar like this

AutoNumber(MonthName(Date)) as MonthCounter

and then use this

Sum({<Year, MonthCounter = {"$(='<=' & Max(MonthCounter))"}>}Sales)

Anonymous — Wed, 27 Jun 2018 07:17:50 GMT

hi,

The month field is available in my data model and if i use the below expression then i am getting correct data for years

Sum({<Year = {"$(='<=' & Max(Year))"}>}Sales) but i want months also

Masi_Sahargahi — Wed, 27 Jun 2018 09:07:13 GMT

Hi,

if you have date field,you can use max of date in set analysis,

I have done a simple scenario in attached file,I hope it can help.

sunny_talwar — Wed, 27 Jun 2018 11:02:24 GMT

You want months also? I am not sure I follow?