Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
bellesol
Creator
Creator

Count by Month - set analysis

Hi,

I have been asked to build a table by month and year that shows the number of open items in a storage.

I want to build a table that would not be affected by the user's selections, the table will display by month and year the amount of items in the storage , for example in February , the relevant data will be all the items that the enter date is less than 28.02.2020, i.e., all the items that enter in January and February 2020.

a table with a dummy data:

*I also attached the excel file*

Capture.PNG

 

For example:

Item that has entered on 15.1.2020 and was out on 21.02.2020, In the "Final column" I need to count this item only one time in  the January month row ,this item will not be calculate on  February because the date out is less the 28.2.2020 .

How can I Build the expression in the "Final column"?

I tried something like this expression:

=count({<[Enter Date]={"=Monthend([Enter Date],0)<=[Date OUT]"}>} [MRB])

 

Labels (3)
3 Replies
bellesol
Creator
Creator
Author

Hi,

Can someone help? 

sunsun566
Contributor III
Contributor III

Hi 

I think you can expand each Item to every day, the formula coding will be much easier.

Hope it helps you:)

agigliotti
Partner
Partner

Hi @bellesol ,

Could you post a sample app with mock data to look at?