topic flag creation problem in QlikView

flag creation problem

Thu, 23 Feb 2012 06:49:06 GMT

hi folks,

i have data like this.

emp no is promotion is manager

1 1 yes

2 0 no

3 1 no

4 0 yes

1. to generate report of managers, non managers ratio , how to create flag for manager, non manager?

2. to generate report of promotion, non promotion ratio, how to create flags

plz help me out in flag creation

vijay_iitkgp — Thu, 23 Feb 2012 06:52:39 GMT

Hi,

Flag is already there in your data. To get Ratio of Manager to Non Manager you can use

Count(If(IsManager='Yes',EmpNo)/Count(If(IsManager='No',EmpNo)

deepakk — Thu, 23 Feb 2012 06:56:05 GMT

HI,

Using Set analysis

Count({<IsManager={"Yes"}>} EmpNo)

Count({<IsManager={"No"}>} EmpNo)

Deepak

jagan — Thu, 23 Feb 2012 06:58:03 GMT

Hi,

Try

For Manager to Non Manager ratio

Count({<[is manager= {'Yes'}>}EmpNo)/Count({<[is manager= {'No'}>}EmpNo)

For Promotion to Non Promotion ratio

Count({<[is promotion= {'1'}>}EmpNo)/Count({<[is promotion= {'0'}>}EmpNo)

Hope this helps you.

Regards,

Jagan.