qlikview set analysis / get associated value of min value of each dimensions

[daniel1990xyz]

Hello together,

I need help regarding a qlikview issue.

I have created a chart / pivot table which groups my data by there "GradParentID" (Dimension). When the dimension is expanded the correct "ticket type" will be shown. My issue is, when the dimension is collapsed I would like to show from the lowest "caseID" the related "Ticket Type". But I am not able to make this working.

I have tried it for example with "FirstSortedValue(TicketType, aggr(Min(caseid),GrandParentID))" in the definition of the expression but the result is not as I want.

I hope I have explained it clearly. I think the attachment will help.

Thank you very much for any help and suggestions.

Many greetings from Germany

Daniel

[maxgro]

maybe

FirstSortedValue(Ticketart, -caseid)

[Kushal_Chawda]

try,

if( dimensionality()=1, FirstSortedValue(TicketType, aggr(Min(caseid),GrandParentID)),Ticketart)

[daniel1990xyz]

Thank you for your suggestions. Unfortunately both are not working as needed. In both ways the script return the ticket type which is the first by alphabetical order from the dimension.