Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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?