Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cseward1963
Contributor

Stacked bar chart legend problem

The data in the bar chart is in order, but the legend is not. In Sorting for 'Grade', I have this expression:

=WildMatch(grade,'Pre-K','K','1','2','3','4','5','6','7','8','9','10','11','12','12+')

Can anyone help?

Picture1.png

2 Replies
sureshqv
Esteemed Contributor III

Re: Stacked bar chart legend problem

cseward1963
Contributor

Re: Stacked bar chart legend problem

Thank you Chanty 4u for the reply.

I looked at the 2 links you posted and am still unclear about how to use this load function in my load script.

This example came from Qlik Community:

load dual ( string,numrep ) as DayOfWeek inline

[ string,numrep

Monday,0

Tuesday,1

Wednesday,2

Thursday,3

Friday,4

Saturday,5

Sunday,6 ];

load Date, weekday(Date) as DayOfWeek from afile.csv;


Now, in my application, the string value would be grade, but I don't know what value to use for the second argument of dual (numrep in the example).