How to apply Entropy Analysis in the qlik sense?

[emilyrabbit]

Hi ,

It is a open discussion. I met the below case , need your help. Thanks in advance. 

I need to show the work load analysis by different people. 

Their daily job include Job1 , Job2 , Job3 , Job4 , Job5 , ( these job is independent, no association)

the daily job workload is linked with the sql server, so it will added day by day;

People	Job1	Job2	Job3	Job4	Job5
A	6	7	60	43	16
B	91	85	13	34	6
C	96	73	46	46	90
D	36	19	60	65	91
E	12	76	22	53	54
F	18	44	17	70	68

Currently , my boss told me the sheet is difficult to read . So , I want to use Entropy Analysis . 

I know how to do in excel. But , I don't how to do in QLIK Sense . 

Beside it , the data will added day by day . So, the number is dynamic.

Pls....

[zar]

Not sure about the goal, but probably first you need to make your data "friendly" for analytics tools, by using crosstable function like this:

DATA:

LOAD * INLINE [

People Job1 Job2 Job3 Job4 Job5

A 6 7 60 43 16

B 91 85 13 34 6

C 96 73 46 46 90

D 36 19 60 65 91

E 12 76 22 53 54

F 18 44 17 70 68

](delimiter IS '\t')

;

DATA_02:

CrossTable(Job_Code, Value,1)

LOAD

*

RESIDENT

DATA

;

DROP TABLE DATA;

Once you have your data in friendly way you may use it in bar chart to see comparison or box plot:

Custom it a little by stacking bars or sorting as desired.

Also consider use Insight Advisor in Qlik to check available analysis suggested by AI.

Hope this helps.

[AnsweringTuring]

To implement Entropy Analysis in Qlik Sense, you can follow these steps:

1. Load the data from the SQL Server database into Qlik Sense using the appropriate data connection and script.
2. Create a new sheet in Qlik Sense and add a pivot table or a table visualization.
3. In the table visualization, add the "People" field as a dimension and the job fields (Job1, Job2, Job3, Job4, Job5) as measures.
4. Right-click on one of the job measure fields and select "New Measure".
5. In the expression editor, create a new measure using the Entropy function. The Entropy function calculates the entropy value based on the distribution of values across the job fields for each person.

The formula for the Entropy measure would be:

Entropy(Sum({1} Job1), Sum({1} Job2), Sum({1} Job3), Sum({1} Job4), Sum({1} Job5))

6. Assign a descriptive name to the new measure, such as "Workload Entropy".
7. Add the "Workload Entropy" measure to the table visualization.

The Entropy value ranges from 0 to 1, where 0 indicates that all the workload is concentrated in a single job, and 1 indicates an equal distribution of workload across all jobs.

By visualizing the Entropy measure alongside the job measures, you can quickly identify the workload distribution patterns for each person. Lower Entropy values indicate a skewed workload towards specific jobs, while higher values suggest a more balanced distribution.

Additionally, since the data is updated daily, you can set up automatic data reloads or incremental loads in Qlik Sense to ensure that the visualizations reflect the latest workload information.