Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
prees959
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
YoussefBelloum
Champion
Champion

5 Replies
YoussefBelloum
Champion
Champion

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

prees959
Creator II
Creator II
Author

Thanks for this it is perfect.

Phil

prees959
Creator II
Creator II
Author

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

YoussefBelloum
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