Calculated Dimension

[hkg_qlik]

Hi,

I am trying to use calculated dimension for a business requirement. The idea is to change the member name to Staff for a few employer name, rest should be same.

Employer Name:        Member Name:               Error Count

123                              Staff                                   3

124                              abc                                    5

125                              cdc                                    6

128                              Staff                                   10

124                              xyz                                     11

If i use if statement in the condition it only takes one value for Employer Name.

eg: =if([Employer Name]= ('123'),'Staff ',[Member Name])

i want to add few more Employer name whose member name should reflect staff.

Any Suggestion??

Regards,

H

[SunilChauhan]

see the attached file

hope this helps

[john_duffy · Accepted solution]

Hello.

With the Match command work for you:

If (match([Employer Name],123,128),'Staff',[Member Name])

John.

[hkg_qlik]

Hi Sunil,

Here I want the calculated dimension because I want to hide the Employee Name as Staff for the Employer Name = 123,128 so on rest should show the original Employee name.

I hope this makes it more clear.

[SunilChauhan]

yes

you ca write below in dimension in attached file

=If (match(EmployerName,123,128),'Staff',MemberName)

hope this helps