This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
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