I am using Qlik Sense now for about 4 years, und normally it works pretty well for the needs my company has.
But today, I have a special problem.
We have a bunch of articles which are beeing loaded into the app (not all). Now, I don't only want the article that satisfy the conditions I have set limits to in the where-clause. I also want those articles that have simillar names.
for exmaple:
The blue pen was beeing purchased in 2024. It is beeing shown because of the limitations made. But I also want the red pen to show up, although it was not purchased in 2024. Both articles are named "pen", only one was beeing purchased, both should be shown.
@Joo525 You can do that but it depends on how you are loading the data. What kind of restriction do you have on data and how do you store your data? Do you have where while loading from source or loading from QVD?
I have different tabels which I join. In the Where-Clause I have for example the restriction of the year. I only want articles purchased 2023 or 2024. Another restriction is the client.
So there are several restrictions.
I am working with 6 tables put together myself in the data editor which are then again joint.
