topic Re: IF then in a table dimension in QlikView

IF then in a table dimension

joshrussin — Wed, 25 Nov 2020 16:16:04 GMT

this is my set expression for my dimension in a table.

=If (Assigned_To_QM = 'Alpha', Assigned_To_QM,

If (Assigned_To_QM = 'Bravo', Assigned_To_QM,

If (Assigned_To_QM = 'Charlie', Assigned_To_QM,

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

I am trying to make an Alpha_1 and an Alpha_2.

I want Alpha_1 to be when Area_QM -= 'yellow' or 'green'

and Alpha_2 to be when Area_QM = 'yellow' or 'green'

If (Assigned_To_QM = 'Alpha', 'Alpha_1',

If (Assigned_To_QM = 'Alpha', 'Alpha_2'))

Any help?

Re: IF then in a table dimension

joshrussin — Tue, 08 Aug 2017 22:05:27 GMT

=If

(Assigned_To_QM = 'Alpha_2'

AND

(Area_QM = 'yellow'

Area_QM = 'green')

, Assigned_To_QM)

This shows no result.

Re: IF then in a table dimension

ahaahaaha — Wed, 09 Aug 2017 07:46:20 GMT

Hi,

May be like this

(Assigned_To_QM = 'Alpha',

If(

Area_QM = 'yellow'

Area_QM = 'green',

Alpha_2,

Alpha_1

))

Regards,

Andrey

Re: IF then in a table dimension

joshrussin — Wed, 09 Aug 2017 16:14:01 GMT

The result i get from this is a table that shows the correct data that is supposed to be for Alpha_2, but is labeled Alpha_1. Then the second row shows a '-' with the total of the rest of the data

Re: IF then in a table dimension

sasiparupudi1 — Thu, 10 Aug 2017 06:11:50 GMT

May be Like this?

=If (Assigned_To_QM = 'Alpha' and Match(Area_QM,'yellow','green'), 'Alpha_1',

If (Assigned_To_QM = 'Alpha' and (Match(Area_QM,'yellow','green')=0), 'Alpha_2'))

Re: IF then in a table dimension

joshrussin — Thu, 10 Aug 2017 14:05:45 GMT

This just gives the row 'Alpha_2'