Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

View only Max Values across Pivot Table Dimension

Hi 

I have data as shown in the Raw Table in the qlikview document attached.

I would like to visualize it like below. where I see the skew1, V1 and T1 values for the Max T1 and on the same row view the skew2, V2 and T2 values for the Max T2

ModeSkew1V1T1Skew2V2T2
Ax0.90014.0z0.74014.1
Bx0.85012.6y0.75013.1

I was able to show only valid values but I had to use skew as a dimension and then it displays blank values for the ones that I do not want to display.

Thanks for looking 🙂

Sid

 

1 Solution

Accepted Solutions
Highlighted

Re: View only Max Values across Pivot Table Dimension

Hi Sid, I made a quick fix using an outer aggr, PFA.

View solution in original post

1 Reply
Highlighted

Re: View only Max Values across Pivot Table Dimension

Hi Sid, I made a quick fix using an outer aggr, PFA.

View solution in original post