Use only Overlapping Months

[Rehan]

I have a requirements where I  have multiple extract dates in a single dataset and each extract date has multiple months .

For example :

Extract Date = May 2019 has Data for May 2019, June 2019, July 2019 up to Dec 2019

Extract Date = Mar 2019 has Data for Mar 2019, Apr 2019 ,May 2019, June 2019 up to Oct 2019

The requirement is I need data for only overlapping months between the 2 extract dates . In this case the overlapping months will be May 2019 Until Oct 2019.

How can I accomplish this ? Idealy I would like to create some sort of a flag in the script to get the overlapping months between 2 extract Dates.

[sunny_talwar]

And this is something you need in the script only or an expression based approach will also work for you?

[Rehan]

I am fine either way, Ideally would like to get both solution if possible si That I will now how it can be done both ways

[sunny_talwar]

Based on the same data attached, try this expression

Sum({<[Forecast Date] = {"=Count(DISTINCT [ETL Date]) = 2"}>} Amount)

[Rehan]

Which script u are using ?

[sunny_talwar]

Just loaded this data

[Rehan]

If i just take the sample data file and load it. I added this expression in a table with ETL Date and Forecast Date as Dimensions it does not work, I can still see all the months in the 2 ETL Dates and not the COMMON months. Any other ideas?

[sunny_talwar]

Did you make selection in two ETL Dates before checking the output?

[Rehan]

Yes I did, Did you get a chance to try on ur side?

[sunny_talwar]

Yup, I did it in QlikView... but I don't think QlikView or Qlik Sense should matter here.... they should work the same way

[Rehan]

Can u pls send me the QVW you created