topic Solution or alternative to a bar chart with 2 or more dimensions and 2 or more expressions in App Development https://community.qlik.com/t5/App-Development/Solution-or-alternative-to-a-bar-chart-with-2-or-more-dimensions/m-p/2126921#M91699 <P>The standard bar chart has the ability to use:<BR />one dimension and multiple expressions<BR />or<BR />two dimensions and one expression.<BR />For a good view I need two dimensions and three expression.<BR />Dimension 1: Year<BR />Dimension 2: Location <BR />Expression 1: confirmed reservation<BR />Expression 2: unconfirmed reservation<BR />Expression 3: Special offers</P> <P>Does anyone have a good idea or alternative?<BR />Regards,<BR />Wouter</P> Tue, 10 Oct 2023 08:25:36 GMT woutermak 2023-10-10T08:25:36Z Solution or alternative to a bar chart with 2 or more dimensions and 2 or more expressions https://community.qlik.com/t5/App-Development/Solution-or-alternative-to-a-bar-chart-with-2-or-more-dimensions/m-p/2126921#M91699 <P>The standard bar chart has the ability to use:<BR />one dimension and multiple expressions<BR />or<BR />two dimensions and one expression.<BR />For a good view I need two dimensions and three expression.<BR />Dimension 1: Year<BR />Dimension 2: Location <BR />Expression 1: confirmed reservation<BR />Expression 2: unconfirmed reservation<BR />Expression 3: Special offers</P> <P>Does anyone have a good idea or alternative?<BR />Regards,<BR />Wouter</P> Tue, 10 Oct 2023 08:25:36 GMT https://community.qlik.com/t5/App-Development/Solution-or-alternative-to-a-bar-chart-with-2-or-more-dimensions/m-p/2126921#M91699 woutermak 2023-10-10T08:25:36Z Re: Solution or alternative to a bar chart with 2 or more dimensions and 2 or more expressions https://community.qlik.com/t5/App-Development/Solution-or-alternative-to-a-bar-chart-with-2-or-more-dimensions/m-p/2126960#M91702 <P>I don't see a solution except maybe with a concatenated dimension with Year &amp; Location together, not perfect but can do a workaround.</P> Tue, 10 Oct 2023 09:26:56 GMT https://community.qlik.com/t5/App-Development/Solution-or-alternative-to-a-bar-chart-with-2-or-more-dimensions/m-p/2126960#M91702 vincent_ardiet_ 2023-10-10T09:26:56Z Re: Solution or alternative to a bar chart with 2 or more dimensions and 2 or more expressions https://community.qlik.com/t5/App-Development/Solution-or-alternative-to-a-bar-chart-with-2-or-more-dimensions/m-p/2127236#M91722 <P>Com base nas suas informações, eu construiria um gráfico com colunas 100% empilhadas com reserva confirmada e não confirmada, cor verde e vermelha respectivamente. E para ofertas especiais, eu incluiria como gráfico de linha. Acredito que assim ficaria mais organizado. Segue imagem abaixo de um gráfico de colunas empilhadas:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="WalterSansdis_0-1696972371463.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/118011i4BEC23C8AC20421B/image-size/medium?v=v2&amp;px=400" role="button" title="WalterSansdis_0-1696972371463.png" alt="WalterSansdis_0-1696972371463.png" /></span></P> <P>&nbsp;</P> <P>É possível adicionar informações nessa janela inteligente (caixa preta).</P> <P>Na imagem acima faltou apenas um gráfico de linha</P> <P>Como não consigo imaginar com precisão como seria sua base de dados, espero que a dica acima possa te ajudar</P> <P>&nbsp;</P> <P>Abs</P> Tue, 10 Oct 2023 20:00:00 GMT https://community.qlik.com/t5/App-Development/Solution-or-alternative-to-a-bar-chart-with-2-or-more-dimensions/m-p/2127236#M91722 WalterSansdis 2023-10-10T20:00:00Z Re: Solution or alternative to a bar chart with 2 or more dimensions and 2 or more expressions https://community.qlik.com/t5/App-Development/Solution-or-alternative-to-a-bar-chart-with-2-or-more-dimensions/m-p/2142713#M92957 <P>Yes, that's what I tried too. But your legend is less readable.<BR />But maybe is this the best solution for the momment.</P> Thu, 30 Nov 2023 08:54:49 GMT https://community.qlik.com/t5/App-Development/Solution-or-alternative-to-a-bar-chart-with-2-or-more-dimensions/m-p/2142713#M92957 woutermak 2023-11-30T08:54:49Z Re: Solution or alternative to a bar chart with 2 or more dimensions and 2 or more expressions https://community.qlik.com/t5/App-Development/Solution-or-alternative-to-a-bar-chart-with-2-or-more-dimensions/m-p/2142715#M92959 <P>I don't understand your answer. I don't want to have stacked dimensions, but I need a group.<BR />The different locations per year. Each location stacked the values ​​of the 3 expressions.<BR />You can do it in QlikView with a bar chart. Choose two dimensions and use 3 expressions.</P> <P>&nbsp;</P> Thu, 30 Nov 2023 08:59:02 GMT https://community.qlik.com/t5/App-Development/Solution-or-alternative-to-a-bar-chart-with-2-or-more-dimensions/m-p/2142715#M92959 woutermak 2023-11-30T08:59:02Z