Count by Month - set analysis

bellesol — Sat, 16 Nov 2024 17:40:44 GMT

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*

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])

Re: Count by Month - set analysis

bellesol — Wed, 23 Dec 2020 08:02:40 GMT

Hi,

Can someone help?

Re: Count by Month - set analysis

sunsun566 — Wed, 23 Dec 2020 08:51:40 GMT

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

Hope it helps you:)

Re: Count by Month - set analysis

agigliotti — Wed, 23 Dec 2020 10:55:46 GMT

Hi @bellesol ,

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

topic Re: Count by Month - set analysis in QlikView

Count by Month - set analysis

Re: Count by Month - set analysis

Re: Count by Month - set analysis

Re: Count by Month - set analysis