https://community.qlik.com/t5/App-Development/Hierarchy-in-set-analisys/m-p/2125299#M91579 <P>Hello everyone, how are you doing? I'm working on a bar chart that has two stacked pieces of information: one is the year, and the other is the type of received values, Credit/Debit, along with the corresponding values. I need to create a drill-down feature where, upon clicking one of the year bars, the months would be displayed. However, I'm having trouble creating a set analysis with drill-down functionality. I did manage to create a hierarchical dimension of year &gt; month, but I can't seem to use it within the set. Here's the formula currently in use: "=pick($(vYearReference), IF([Year Adjustment] &gt;= 2022, [Year Adjustment]), IF([Year Written] &gt;= 2022, [Year Written]), IF([Year Invoiced] &gt;= 2022, [Year Invoiced]))". Can anyone help me with this?</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="hanschucrutes_0-1696456011533.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/117640i908BA1D65E856039/image-size/medium?v=v2&amp;px=400" role="button" title="hanschucrutes_0-1696456011533.png" alt="hanschucrutes_0-1696456011533.png" /></span></P> <P>&nbsp;</P> Wed, 04 Oct 2023 21:53:59 GMT hanschucrutes 2023-10-04T21:53:59Z https://community.qlik.com/t5/App-Development/Hierarchy-in-set-analisys/m-p/2125299#M91579 <P>Hello everyone, how are you doing? I'm working on a bar chart that has two stacked pieces of information: one is the year, and the other is the type of received values, Credit/Debit, along with the corresponding values. I need to create a drill-down feature where, upon clicking one of the year bars, the months would be displayed. However, I'm having trouble creating a set analysis with drill-down functionality. I did manage to create a hierarchical dimension of year &gt; month, but I can't seem to use it within the set. Here's the formula currently in use: "=pick($(vYearReference), IF([Year Adjustment] &gt;= 2022, [Year Adjustment]), IF([Year Written] &gt;= 2022, [Year Written]), IF([Year Invoiced] &gt;= 2022, [Year Invoiced]))". Can anyone help me with this?</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="hanschucrutes_0-1696456011533.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/117640i908BA1D65E856039/image-size/medium?v=v2&amp;px=400" role="button" title="hanschucrutes_0-1696456011533.png" alt="hanschucrutes_0-1696456011533.png" /></span></P> <P>&nbsp;</P> Wed, 04 Oct 2023 21:53:59 GMT https://community.qlik.com/t5/App-Development/Hierarchy-in-set-analisys/m-p/2125299#M91579 hanschucrutes 2023-10-04T21:53:59Z https://community.qlik.com/t5/App-Development/Hierarchy-in-set-analisys/m-p/2125382#M91586 <P>Hi,</P> <P>You should try creating the single Year field in backend using <SPAN>[Year Adjustment],[Year Written],[Year Invoiced]&nbsp;field</SPAN></P> Thu, 05 Oct 2023 06:29:39 GMT https://community.qlik.com/t5/App-Development/Hierarchy-in-set-analisys/m-p/2125382#M91586 pallavsi_08 2023-10-05T06:29:39Z