Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Do we have the 'Reduce Data' with 'Keep Possible Values' functionality in Qlik Sense, like we had in QlikView (anything apart from the ODAG option)?
or Do we have an API that will help us achieve this functionality?
We have a big application that we would like to split into multiple small apps based on custom Selected + Possible Values, any pointers would be helpful.
Ideally we would like to do this reduction on a scheduled basis (similar to the loop and reduce functionality)..
Thanks,
KD
I don't see such so far, have a look https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Reduce_Data1.ht...
Yes, there is a valid option that only requires LOAD-script. PS. I posted this answer in another thread as well, but I think this could be the solution here as well...
I have tested to do this in just the load-script at the "end" of the applications load-script. It works perfectly, it even works in combination with Section Access. I will just explain the concept.
Prerequisites: Needs developer that is able to do "Advanced"? LOAD-script programming.
Big advantages: JUST "simple" LOAD-script. NO Section Access is needed for reduction. NO use of any API.
PS. I only tested it with 1 Field. But I think it should work, even with more than one field easily if the fields are in the same table, otherwise it could become to complex.
The implementation/concept (working!):
Write a LOAD script that you put at the END (but before possible Section Access script). The script should contain the following steps:
Some implementation thoughts:
Hope this helps!
John