Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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).