Hi,
I have a report that currently works fine with a small exception.
The report in Qlik Nprinting sends customers sales data from stores per week in a given year.
The only variables that are selected are Year (maximum).
And there is a problem because you have to compare ALL stores from the maximum year and the Max(Year)-1, and sometimes the store closes, so by selecting year = 2024, stores closed in 2023 will not be displayed due to lack of data.
How can I get around this so that stores closed in 2023 are displayed?
Add some artificial table with only stores and sels equal to zero?
Thanks & Regards,
Please close the thread by marking correct answer & give likes if you like the post.
