topic Calculated Dimension in QlikView

Calculated Dimension

hkg_qlik — Tue, 01 May 2012 15:04:08 GMT

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,

Re: Calculated Dimension

SunilChauhan — Tue, 01 May 2012 15:11:47 GMT

see the attached file

hope this helps

Re: Calculated Dimension

john_duffy — Tue, 01 May 2012 15:15:23 GMT

Hello.

With the Match command work for you:

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

John.

Calculated Dimension

hkg_qlik — Tue, 01 May 2012 15:17:40 GMT

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.

Calculated Dimension

SunilChauhan — Tue, 01 May 2012 15:18:33 GMT

yes

you ca write below in dimension in attached file

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

hope this helps