Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New 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