Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
kamalqlik
Partner - Specialist
Partner - Specialist

Current stock Issue

Hi Friends,

                 I am facing a problem while calculating the Current stock.

I am working on a database that is from Mar-2011 to till date.

I am attaching the qvd needed for this.In this there is a date field ENTDT and Qty will be stock.Data will be considered from Mar-2011.

Now what i want to do is that when a user select the month and year the Cureent stock shold be sum from starting date and date selected.

ie it must be from March-2011 which will be same to the date selected by user.

I am using the max(ENTDT) but i am not getting the appropite result

Thanks in advance

Regards

Kamal

1 Solution

Accepted Solutions
Not applicable

Hi,

Please find the attached file.

Let me know if any issue.

Regards!

View solution in original post

3 Replies
Not applicable

Hi,

Please find the attached file.

Let me know if any issue.

Regards!

kamalqlik
Partner - Specialist
Partner - Specialist
Author

Hi Ashu,

               Thanks for the reply.But when i make Month and Year field from the date field,and on selection of Month and Year it is not giving sum.

Regards

Kamal

Not applicable

Hi,

Hope Attached Application helps you  with Year & Month Selection.