Discussion Board for collaboration related to QlikView App Development.
I have a dataset that comprises of :
I also have a measure of 'Total Absences'
What I would like to be able to do is historically portray which Office Area, Staff Role and Shift had the most absences - so going forward this can be monitored.
I realise I can do this in a pivot and produce a heatmap, but is there way I can score this data during the load process to add a score to this data?
Many thanks for any advice / help.
View solution in original post
You can take the Officeafrea, StaffRole , Shift in the dimension and use something like the rank function to get who fared better
rank( sum('Total Absences') )
Thanks for this it is perfect.
Is there anyway to achieve this rank within the script load? I would like to create a resident table and then export this to CSV.
in the app attached, the rank was already done in the script, take a look !
you can also add a: STORE TABLE into TABLENAME.csv(txt); to directly export your table