topic Re: Arranging a stacked bar chart in QlikView https://community.qlik.com/t5/QlikView/Arranging-a-stacked-bar-chart/m-p/1127202#M913476 <HTML><HEAD></HEAD><BODY><P>Try to create the correct order of your categories when creating them in the script:</P><P></P><P>either create a load order that is correct, e.g. by creating an INLINE table before you are loading your categories:</P><P></P><P>LOAD * INLINE [</P><P>Category</P><P>Very bad</P><P>Bad</P><P>Regular</P><P>Good</P><P>];</P><P></P><P>Then load your other tables. You can drop the INLINE table at the end of your script, if you want.</P><P>Then set the sort order of Category to load order on Sort tab of your chart.</P><P></P><P>or create a dual value when creating / loading your Categories:</P><P></P><P>LOAD </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Dual(Category, Match(Category, 'Very bad','Bad','Regular','Good')+1 ) as Category,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ...</P><P></P><P>Then sort the Category values numeric.</P><P></P><P>Hope this helps,</P><P>Stefan</P></BODY></HTML> Sun, 05 Jun 2016 10:10:53 GMT swuehl 2016-06-05T10:10:53Z Arranging a stacked bar chart https://community.qlik.com/t5/QlikView/Arranging-a-stacked-bar-chart/m-p/1127201#M913475 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P>I am a beginner in Qlikview and i want to make a question and see if you can help me .How can I arrange a stacked bar chart in the folllowing order by category from Very bad , bad , regular and good?.</P><P>In the attached image, the categories are in spanish. </P><P>Regards from Chile</P><P><IMG alt="chart.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/126878_chart.jpg" style="height: 324px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Arranging-a-stacked-bar-chart/m-p/1127201#M913475 ale_nilo84 2020-11-25T16:16:04Z Re: Arranging a stacked bar chart https://community.qlik.com/t5/QlikView/Arranging-a-stacked-bar-chart/m-p/1127202#M913476 <HTML><HEAD></HEAD><BODY><P>Try to create the correct order of your categories when creating them in the script:</P><P></P><P>either create a load order that is correct, e.g. by creating an INLINE table before you are loading your categories:</P><P></P><P>LOAD * INLINE [</P><P>Category</P><P>Very bad</P><P>Bad</P><P>Regular</P><P>Good</P><P>];</P><P></P><P>Then load your other tables. You can drop the INLINE table at the end of your script, if you want.</P><P>Then set the sort order of Category to load order on Sort tab of your chart.</P><P></P><P>or create a dual value when creating / loading your Categories:</P><P></P><P>LOAD </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Dual(Category, Match(Category, 'Very bad','Bad','Regular','Good')+1 ) as Category,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ...</P><P></P><P>Then sort the Category values numeric.</P><P></P><P>Hope this helps,</P><P>Stefan</P></BODY></HTML> Sun, 05 Jun 2016 10:10:53 GMT https://community.qlik.com/t5/QlikView/Arranging-a-stacked-bar-chart/m-p/1127202#M913476 swuehl 2016-06-05T10:10:53Z Re: Arranging a stacked bar chart https://community.qlik.com/t5/QlikView/Arranging-a-stacked-bar-chart/m-p/1127203#M913477 <HTML><HEAD></HEAD><BODY><P>Perfect, thank you very much for the help</P></BODY></HTML> Sun, 05 Jun 2016 15:33:48 GMT https://community.qlik.com/t5/QlikView/Arranging-a-stacked-bar-chart/m-p/1127203#M913477 ale_nilo84 2016-06-05T15:33:48Z