Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER 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
Partner

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
Partner

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
Partner

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
Partner

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
Partner

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

View solution in original post

Sameer9585
Creator II
Creator II
Author

Thanks a lot