Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
cseward1963
Creator
Creator

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
cseward1963
Creator
Creator
Author

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).