Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
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

 

Labels (3)
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.