Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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).