Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
Highlighted
Not applicable

More Hierarchy and Data Issues

I’m trying to get my Results View Pivot table to be in hierarchical order similar to my Criteria listbox and show only the Top Level Criteria with the lines of data as shown in the first and second examples in my attached excel file and below. I have tried a few things, but I continue to get missing data when I collapse the pivot table data and the Sublevel Criteria is still not in order of the “ – “ character coming before the other Subjects or defaulting to it when the Top Level Criteria is collapsed or expanded.


What it should look like collapsed:


   

Top Level CriteriaAlternativesAlt 1Alt 2Alt 3Alt 4Alt 5Alt 6Alt 7Alt 8Alt 9Alt 10Alt 11
Test Group 1 0.910.76-0.25-0.250.88-0.020.250.710.710.780.78
Test Group 2 0.000.50-0.50-0.501.00-0.500.000.501.001.001.00
Test Group 3 0.580.66-0.250.330.350.750.500.701.000.580.85
Test Group 4 0.640.70-0.44-0.180.680.370.610.870.630.010.02
Test Group 5 0.001.00-0.50-0.501.000.001.001.001.001.001.00
Test Group 6 0.671.00-0.50-0.500.95-0.170.170.670.480.190.28
Test Group 7 0.000.310.150.330.450.740.660.520.280.320.36
Test Group 8 0.601.00-0.50-0.500.74-0.500.430.301.001.001.00
Test Group 9 1.000.75-0.50-0.501.00-0.500.000.000.000.000.00
Test Group 10 -0.501.000.000.000.900.000.700.400.900.500.50

What it should look like when one of the Test Groups is expanded:

    

Top Level CriteriaSublevel CriteriaAlternativesAlt 1Alt 2Alt 3Alt 4Alt 5Alt 6Alt 7Alt 8Alt 9Alt 10Alt 11
Test Group 1- 0.910.76-0.25-0.250.88-0.020.250.710.710.780.78
Test Group 1Subject 1 1.001.00-0.50-0.500.90-0.501.000.900.901.001.00
Test Group 1Subject 2 1.000.60-0.50-0.500.70-0.500.001.000.500.700.70
Test Group 1Subject 3 1.001.00-0.50-0.501.00-0.500.00-0.50-0.50-0.50-0.50
Test Group 1Subject 4 0.270.480.000.040.410.350.500.290.761.001.00
Test Group 1Subject 5 1.001.00-0.50-0.501.00-0.501.001.001.001.001.00
Test Group 1Subject 6 1.000.00-0.50-0.501.00-0.50-0.501.001.001.001.00
Test Group 1Subject 7 1.001.00-0.50-0.501.001.000.001.001.001.001.00
Test Group 1Subject 8 1.001.001.001.001.001.000.001.001.001.001.00

As you will see in the attached .qvw, it is not what I'm receiving.

Any help with this would be greatly appreciated and thank you for taking a look at this.


Preston

1 Solution

Accepted Solutions

Re: More Hierarchy and Data Issues

May be this:

If(vToggle = 1, Avg(Data), ' ')

Capture.PNG

Capture.PNG

View solution in original post

2 Replies

Re: More Hierarchy and Data Issues

May be this:

If(vToggle = 1, Avg(Data), ' ')

Capture.PNG

Capture.PNG

View solution in original post

Not applicable

Re: More Hierarchy and Data Issues

Thanks Sunny! You have saved the day again. I couldn't get past my narrow thinking on the dimension issue. I also found that the actual data I'm working on wouldn't collapse correctly because the Top Level Criteria had different numbers attached after each one. It gave me a headache, but I'm slowly putting the pieces together with this software thanks to great people like you and the community in general. Thanks again for providing another learning experience!

Warm Regards,

Preston