Collapsible rows in straight table similar to pivot

edwin — Tue, 01 Sep 2020 15:45:46 GMT

this is more to share what weve done in case someone else had the same requirement and also hoping someone else has a more elegant solution (aside from use of extensions)

the requirement we were presented was to show collapsible rows showing summaries and allowing the user the capability to expand those rows. pretty much like a pivot table except all the dimensions are in a single column. This is basically a visualization exercise as the users dont like the way space is wasted with pivot tables:

<table><tr><td>Dimension</td><td>Measure</td></tr>
<tr><td>+ Header1</td><td>100</td></tr>
<tr><td>+ Header2</td><td>150</td></tr>
</table>

when the user clicks on HEADER1, it expands and shows the corresponding components:

<table><tr><td>Dimension</td><td>Measure</td></tr>
<tr><td>- Header1</td><td>100</td></tr>
<tr><td> Detail1</td><td>20</td></tr>
<tr><td> Detail2</td><td>80</td></tr>
<tr><td>+ Header2</td><td>150</td></tr>
</table>

the solution requires triggers to capture what the user has clicked and save that value in a list of values that are expanded. clicking again removes from the list of expanded values. of course the filtered field is cleared to allow the straight table to show all values.

ive attached a sample QVW with the variables used and the triggers.

if you have suggestions to improve on it (esp a solution not using triggers and not using extensions) pls share. Note we built an extension that does all of these but our org frowns upon extensions

edwin

Re: Collapsible rows in straight table similar to pivot

Kushal_Chawda — Tue, 01 Sep 2020 16:09:18 GMT

Is there any specific reason to do this way in straight table?

Re: Collapsible rows in straight table similar to pivot

edwin — Tue, 01 Sep 2020 16:28:03 GMT

as i said, it was a visualization exercise as the pivot table took up a lot of space, this way we can incorporate multiple columns into one and the only overhead was the spacing added per level of the hierarchy. whereas in pivot, we will use multiple columns and each column will need to be compressed.

Re: Collapsible rows in straight table similar to pivot

edwin — Tue, 01 Sep 2020 16:30:07 GMT

also i thought it was an elegant alternative to a pivot table.

topic Collapsible rows in straight table similar to pivot in QlikView

Collapsible rows in straight table similar to pivot

Re: Collapsible rows in straight table similar to pivot

Re: Collapsible rows in straight table similar to pivot

Re: Collapsible rows in straight table similar to pivot