topic Re: If Statement in a Dimension in QlikView

If Statement in a Dimension

joshrussin — Wed, 09 Aug 2017 20:37:09 GMT

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)

Re: If Statement in a Dimension

Anil_Babu_Samineni — Thu, 10 Aug 2017 03:14:29 GMT

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'))))))

Re: If Statement in a Dimension

joshrussin — Thu, 10 Aug 2017 13:58:27 GMT

this is what comes up..