Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Sameer9585
Creator II
Creator II

Rolling sum till selected month

hi,

I have problem in which the data is containing customer, month, year and sales and I will provide the data set below.I need the output as mentioned in the data set (sheet 2) please look into it ad provide me the solution.

Thanking You in advance,

1 Solution

Accepted Solutions
shair_abbas
Partner - Creator
Partner - Creator

Sorry i forgot to include your requirement. Please find the attached file it serves the purpose.

View solution in original post

9 Replies
shair_abbas
Partner - Creator
Partner - Creator

Hi,
I need to know how you are going to make relation between Customer and Country?
Sameer9585
Creator II
Creator II
Author

I have not given country in the field only.
shair_abbas
Partner - Creator
Partner - Creator

Well that doesn't make sense or am i not getting some thing?
according to provided sample data how could you know Sameer or Gurave are customer of PAK,IND or any other country.
Sameer9585
Creator II
Creator II
Author

this the data set

Sameer9585
Creator II
Creator II
Author

Sorry for that file
shair_abbas
Partner - Creator
Partner - Creator

Some thing like attached Qvf file?

Sameer9585
Creator II
Creator II
Author

I require the cumulative sum if I select a month for suppose if I select may It should display sales till may that is for 2017 is 1881,71248,23713 etc for Gaurav
shair_abbas
Partner - Creator
Partner - Creator

Sorry i forgot to include your requirement. Please find the attached file it serves the purpose.

Sameer9585
Creator II
Creator II
Author

Thanks a lot