topic Re: Set Analysis, 1 Dimension & 2 Facts Tables in QlikView

Set Analysis, 1 Dimension & 2 Facts Tables

Thu, 27 Aug 2015 04:00:53 GMT

Dear Expert,

I have a data model like this :

From that, I can make a data of Employee Detail and Employee Absence Days :

My question is, what is the best script expression to make an analysis of Total All Employee versus Total Employee who make an absence ?

For example, ORG_DESC = 'ACC' have 10 total employees, and have 3 employees who make an absence. So the expression is 3/10 = 30%.

Anyone can help me? Thank you.

Denny Setiawan

Re: Set Analysis, 1 Dimension & 2 Facts Tables

sunny_talwar — Thu, 27 Aug 2015 04:19:46 GMT

Are you looking to do this in the above Pivot table or are you going to create a new table for this??? If you are planning to create a new table then may be add ORG_DESC as your dimension and this as expression

Count(DISTINCT {<ABSENSE_REASON = {"?*"}>}EMP_NAME)/Count(DISTINCT EMP_NAME)

Re: Set Analysis, 1 Dimension & 2 Facts Tables

Thu, 27 Aug 2015 04:37:43 GMT

Thank you Sunny.

Finally I can make this analysis

Regards,

Denny Setiawan

Re: Set Analysis, 1 Dimension & 2 Facts Tables

sunny_talwar — Thu, 27 Aug 2015 04:44:28 GMT

Great

I am glad you are able to figure it out.

Best,

Sunny