topic Pivot table - Challenge in QlikView

Pivot table - Challenge

priya945 — Sat, 16 Nov 2024 18:57:24 GMT

Hi All, I have a Pivot table in QV as below when expanded

When user collapse, Pivot table looks like below where dates are not showing and values are summing up.

Requirement is When user collapse then the last date with values should be shown instead of blank date and sum up of all as below

Please advise if this can be achieved in pivot table

Thank You

sunny_talwar — Thu, 12 Mar 2020 15:00:17 GMT

You can get the latest month's value, but not sure how you would display the month itself

=If(SecondaryDimensionality() = 2, Sum(Value), FirstSortedValue(Aggr(Sum(Value), Field, Region, Date), -Aggr(Date, Field, Region, Date)))

priya945 — Fri, 13 Mar 2020 07:25:26 GMT

Thanks Sunny.

Yes got the solution partially and the challenge would be date.

Anyways thanks once again.