How to Display Double Aging Bucket in Single Pivot table?

[shah_jigesh16]

Hi All,

We have a requirement where we would like to display 2 aging buckets in single Pivot table in Qlikview.

For Example: Create below 2 fields for each record in the table.

Transfer Bucket = [Transfer Date] - [Start Date] and create a bucket field "Transfer_Aging".

Active Bucket = [Active Date] - [Start Date] and create a bucket field "Active_Aging".

Bucket creation was done as expected. But the issues we are facing is on how to display above 2 bucket fields in same Pivot table.

Please find attached image on the expected output.

Please help on achieving the results as shown in attachment.

Thanks and regards,

Jigesh

[MarcoWedel]

thanks,

actually this approach does not change the number of rows of the main table, instead the age days and buckets are loaded in a separate table.

This additional table and the %Key field add to the memory footprint, yes, but on the other hand age bucket values only have to be stored in a single field.

I guess it depends on the source data, which of both effects predominates.

maybe helpful:

Symbol Tables and Bit-Stuffed Pointers

regards

Marco

[shah_jigesh16]

Hi Manas ,

Thank you for the efforts. But was looking more at dynamic Bucketing in script which Marco's solution will help getting that.

Have marked you solution as Helpful as we cannot mark 2 replies as Correct..

Thank you once again.

[shah_jigesh16]

Hi Marco,

Thank you for the solution. Dint really think of using Crosstable using resident load.

Performance isn't an issue as data size is not huge.

It really helped a lot.

Thank you for the overall support.

Thanks and Regards,

Jigesh D Shah

[manas_bn]

Sure Jigesh. That was the better solution. I would have used it myself!