topic Re: Nested IF in App Development

Nested IF

Samanehsorournejad — Sat, 23 Apr 2022 15:12:38 GMT

Hi Every body,

I want try to write the nested if with this Conditions:

if just column [DWH:Pentaho Abbruch]=1 then 'Pentaho' else if column [DWH:Qlikview Abbruch]=1 then 'Qlikeview'

else if both of them are equal 1 then 'Pentaho and Qlik View'. I had write this formula but I could not understand what is my Fault. it gives me Error.

If( [DWH:
Pentaho Abbruch]=1, 'Pentaho',if([DWH:
Qlikview Abbruch]=1,'Qlikeview',if([DWH:
Pentaho Abbruch]=1 and [RZV:
Qlikview Abbruch]=1, 'Pentaho and Qlik View')))

Please help me 😞

Re: Nested IF

vinieme12 — Sat, 23 Apr 2022 15:16:55 GMT

You logical order was incorrect, the if() will end after first condition that is true

Try below

=if(rangesum([DWH:Pentaho Abbruch],[RZV:Qlikview Abbruch])=2,'Pentaho and Qlik View'

,if([DWH:Pentaho Abbruch]=1,'Pentaho'

,if([DWH:Qlikview Abbruch]=1,'Qlikeview','None of Above')))

Re: Nested IF

Samanehsorournejad — Sat, 23 Apr 2022 16:50:24 GMT

Hi Vineeth,

it did not unfortunately works. It shows for all cells 'None of Above'

Re: Nested IF

vinieme12 — Sat, 23 Apr 2022 17:03:20 GMT

are the values actually numeric??

what does isnum([DWH:Pentaho Abbruch]). return ? 0 means not numeric. , -1 means numeric

Re: Nested IF

vinieme12 — Sat, 23 Apr 2022 17:05:38 GMT

incase they are not numeric try below

=if(index([DWH:Pentaho Abbruch],'1') and index([RZV:Qlikview Abbruch],'1') ,'Pentaho and Qlik View'

,if(index([DWH:Pentaho Abbruch],'1'),'Pentaho'

,if(index([DWH:Qlikview Abbruch],'1'),'Qlikeview','None of Above')))

Re: Nested IF

Samanehsorournejad — Sun, 24 Apr 2022 07:44:36 GMT

Hi Vineeth,

isnum([DWH:Pentaho Abbruch]) return 0 for all rows execp the first rows that returns -1 and I had try to this:

=if(index([DWH:Pentaho Abbruch],'1') and index([RZV:Qlikview Abbruch],'1') ,'Pentaho and Qlik View'

,if(index([DWH:Pentaho Abbruch],'1'),'Pentaho'

,if(index([DWH:Qlikview Abbruch],'1'),'Qlikeview','None of Above')))

but again give me the error.

Re: Nested IF

vinieme12 — Sun, 24 Apr 2022 08:36:14 GMT

What is the error that you get ? Please post a screenshot or some sample data

Re: Nested IF

Samanehsorournejad — Sun, 24 Apr 2022 13:17:31 GMT

Hi Vineeth,

I had change the type of Columns to Integer and tried this Formula:

=if(RangeSum([DWH:
Pentaho Abbruch],[DWH:
Qlikview Abbruch])=2,'Qlikview and Pentaho',if([DWH:
Qlikview Abbruch]=1,'Qlikview', if([DWH:
Pentaho Abbruch]=1,'Pentaho','Non of Abov')))

the Error just write : Error in expression

and in my table for all case it just show "Non of Abov"

Re: Nested IF

vinieme12 — Sun, 24 Apr 2022 13:56:29 GMT

I think you are trying to add this as a dimension and not a measure

For a calculated dimension, you need to wrap this in Aggr()

Aggr(if(index([DWH:Pentaho Abbruch],'1') and index([RZV:Qlikview Abbruch],'1') ,'Pentaho and Qlik View'

,if(index([DWH:Pentaho Abbruch],'1'),'Pentaho'

,if(index([DWH:Qlikview Abbruch],'1'),'Qlikeview','None of Above')))

,SomeIdOrKeyField)

SomeIdOrKeyField, this field needs to be at lowest granularity, that is row level

Re: Nested IF

Samanehsorournejad — Sun, 24 Apr 2022 14:21:15 GMT

Hi Vineeth ,

I had change the type of Columns to Integer and write the Formula in the Order that you at first told me and its Works,

=if(rangesum([DWH:Pentaho Abbruch],[RZV:Qlikview Abbruch])=2,'Pentaho and Qlik View'

,if([DWH:Pentaho Abbruch]=1,'Pentaho'

,if([DWH:Qlikview Abbruch]=1,'Qlikeview','None of Above')))

my Fault were:

1- Orders of IF Condition

2- Type of Column that should be Change in Integer

🙂

Thanks a lot Vineeth

Re: Nested IF

Samanehsorournejad — Sun, 24 Apr 2022 14:23:34 GMT

Hi again Vineeth ,

just another question, I don't Know exactly when I should write the Formula as Measure and when I should write it as Dimension?

Re: Nested IF

vinieme12 — Sun, 24 Apr 2022 15:31:33 GMT

any fields that you would use aggregations functions such as Sum(), Count(), max(), min(), rangesum() etc ….

are your measures

Dimensions are what you would group your measures by

for examples sum(Sales) by Country

So country is a dimension and sum(Sales) is your measure

Dimensions contain qualitative values (such as names, dates, or geographical data). You can use dimensions to categorize, segment, and reveal the details in your data. Dimensions affect the level of detail in the view.
Measures contain numeric, quantitative values that you can measure. Measures can be aggregated. When you drag a measure into the view, Tableau applies an aggregation to that measure (by default).

https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Scripting/AggregationFunctions/aggregation-functions.htm#:~:text=The%20family%20of%20functions%20known,clause%20in%20the%20script%20statement.