Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. 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