Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm totally new to QlikSense, so please bear with me.
I'm making a pivot table, and I'd like to remove the values once I reached the target (100%), how can I do that?
Thanks for any hints in advance.
you can do a rangesum and then test if the rangesum >= your threshold. here is a great piece on rangesum. it was written for QlikView but should also work for Qlik Sense
Running totals per dimension (RangeSum(), sortable... - Qlik Community - 1487351