Forum Discussion

eiprakash's avatar
eiprakash
Frequent Visitor
8 years ago
Solved

Create Measure on chart

I have the following structure. 2 tables - Hires and Employee connected by a key.    I would like to create a ratio field = Count of hires / Count of Employee.   I am a Qlikview user moving to Po...
v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
8 years ago

Hi eiprakash,

Could you mean show the formula in the visual? If so, I am afraid you could not achieve this feature currently, but you could add a text box beside the visual:

If I misunderstand you, please let me know as soon as possible.

 

Regards,

Daniel He

  • eiprakash's avatar
    eiprakash
    Frequent Visitor
    8 years ago

    Greatly appreciate your help !!Below would be the Mock up data. Table A and B are connected using the Key Cost Center. I would like to calculate Hiring rate as a measure.

     

    Hiring Rate = Count of EmpNo.Hires (From TableA)  / Count of EmpNo.Active(From TableB) = 3/5 (Answer)

     

    Table A:

     

    EmpNo. Hires    CostCenter

    2                         234

    3                         235

    4                         236

     

    Table B:

     

    EmpNo. Active    CostCenter

    5                         234

    4                        235

    7                         236

    9                        232

    2                        231