Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
sidjustice
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
rubenmarin

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

View solution in original post

1 Reply
rubenmarin

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

View solution in original post