Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Add Weighting to Data Values

Hi ,

I have a dataset that comprises of :

  • Office Area (eg, floor1, floor2, floor3, floor4, etc)
  • Staff Role (eg, Supervisor, Telephone Operator, Receptionist, Floor Manager etc)
  • Shift (eg, Morning, Late, Night, All Day, All Night etc)

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.

Phil 

1 Solution

Accepted Solutions
Highlighted
Champion
Champion

5 Replies
Highlighted
Champion
Champion

Highlighted
Specialist II
Specialist II

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

Highlighted
Creator II
Creator II

Thanks for this it is perfect.

Phil

Highlighted
Creator II
Creator II

Hi Youssef,

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.

Thanks,

Phil

Highlighted
Champion
Champion

Hi Phil,

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