This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
please help me on this requirement
MTD Contact = Manager
(WHEN data= MDS, Contact Name = “Juli ”
WHEN data= MIS, Contact Name = “Test”
WHEN data= Pharma, Contact Name = “peenot”
WHEN data= Corporate, Contact Name = “trisha “ )
MTD Contact = Solution Manager
(Contact Name = solution_manager_name)
MTD Contact = Project Manager
(Contact Name = project_manager)
Note:here MTD Contact and data is two field names and i have to derive a new field called Contact Name
please give if condition in qlikview
Maybe something along these lines
IF( [MTD Contact] = 'Manager',
If([MTD Contact] = 'Solution Manager', 'solution_manager_name', // or is this a field? Don't know..
If([MTD Contact] = 'Project Manager', 'project manager')
AS [Contact Name],
Another option would be to use Mapping Load. I am loading the data using Inline load, but you can maintain this data in an excel file. This makes the maintenance of the data slightly easier compared to if statement.
LOAD [MTD Contact]&'|'&data as Field1,
LOAD * Inline [
MTD Contact, data, Mapped
Manager, MDS, Juli
Manager, MIS, Test
Manager, Pharma, peenot
Manager, Corporate, trisha
Solution Manager, , solution_manager_name
Project Manager, , project_manager
LOAD [MTD Contact],
ApplyMap('MappingTable', [MTD Contact]&'|' &If([MTD Contact] = 'Manager', data)) as [Contact Name],
MTD Contact, data, sales
Manager, MDS, 100
Solution Manager, xyz, 400
Project Manager, ysh, 320
Manager, MIS, 672
Manager, Pharma, 392
Manager, Corporate, 832