If Statement in a Dimension

[joshrussin]

Hey guys,

I am trying to create a table in Qlikview.

I am attempting a nested If statement to get select data from database as a dimension.

Although there are some names I am having some issues with. Ex. Candace has different kind of clients and needs to be broken down into MI and Non-MI. So if you look in the pic below, it shows the different Candy rows.

I have tried this, and it doesn't work either.

If (Assigned_To_QM = 'Candace Bennett'

  , If(Match(Client_QM, 'HT Medical', 'SeaSpine', 'SMV Scientific')

    , 'Candy MI'

    , If(Match(Client_QM, 'ConforMIS, Inc.', 'Integra', 'Mako Surgical')

      , 'Candy Non-MI'

      , Assigned_To_QM))

If (Assigned_To_QM = 'Anwar Powell', 'Bravo',

If (Assigned_To_QM = 'Cody Grisanti', 'Charlie',

If (Assigned_To_QM = 'Christine Lane', 'Delta'))))

The goal is for the table to look similar to this. (the values will differ slightly due to updated database)

[Anil_Babu_Samineni]

May be this?

If(Match(Assigned_To_QM , 'Candace Bennett'),If(Match(Client_QM, 'HT Medical', 'SeaSpine', 'SMV Scientific'), 'Candy MI', 

  If(Match(Client_QM, 'ConforMIS, Inc.', 'Integra', 'Mako Surgical'), 'Candy Non-MI',

    If(Match(Assigned_To_QM, 'Anwar Powell'), 'Bravo',

      If(Match(Assigned_To_QM, 'Cody Grisanti'), 'Charlie',

If(Match(Assigned_To_QM, 'Christine Lane'), 'Delta'))))))

[joshrussin]

this is what comes up..