I have a bit of a problem, that sounds easy - but I have not yet figured out how to do it properly in QlikView script editor.
I have periods something like this in my data:
And we are only interested of loading the data with the latest 6 period.
I have kind a managed to do that with my example Qlik-app, but it does not have distinct values on the filtering table. And it causes the massive data amount to not to load correctly. With this size of sample data, it goes through just fine, but not in real world scenario.
So, we have these periods.
We load them with the data we have, at first they are separately so they have been concatenated to one field called "period".
From these periods, we want to show and maybe also to load the six latest ones, that in this case are the following periods:
So, the data from these periods only and everything else can be left out.
But when I load the data, it gets 18 rows for the table3 where i should only have distinct period values.Why isn't this working as the way I want?
There might be a better way to do this than the one I have on my QV app at the moment, and suggestions can be left here also
If you guys have any idea how to handle this, it would be really lovely to know!