topic Re: Add Weighting to Data Values in QlikView

Add Weighting to Data Values

prees959 — Thu, 26 Oct 2017 08:47:29 GMT

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

Re: Add Weighting to Data Values

YoussefBelloum — Thu, 26 Oct 2017 09:04:57 GMT

Hi,

Find attached

Re: Add Weighting to Data Values

qliksus — Thu, 26 Oct 2017 11:50:52 GMT

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

Re: Add Weighting to Data Values

prees959 — Fri, 27 Oct 2017 09:44:26 GMT

Thanks for this it is perfect.

Phil

Re: Add Weighting to Data Values

prees959 — Thu, 02 Nov 2017 21:09:54 GMT

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

Re: Add Weighting to Data Values

YoussefBelloum — Fri, 03 Nov 2017 08:34:16 GMT

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