Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

roccoxpecora
New Contributor III

Nested IF Statements

Hello Qlik Users,

I need to have some nested if statements to turn ranges of scores into buckets.

My field is 'Total Score' and I need a bucket for scores greater than 99.99, scores between 99.99-95, and 94-90.

If some one could help with the syntax for multiple if statements that would be great.

Thanks

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Nested IF Statements

Hi

Please try this expression .

If( [Total Score] > 99.99, 'A',

        If([Total Score] <=99.99 and [Total Score] >=95),'B',

            If([Total Score] <95 and [Total Score] >=90,'C','D')))

                                       

15 Replies
MVP
MVP

Re: Nested IF Statements

Maybe something like

If( [Total Score] > 99.99, dual( '> 99.99', 100),

                                        If([Total Score] >=95, Dual('95 - 99.99', 95),

                                                                           If([Total Score] >=90 , Dual('90 - 95', 90) )

                                        )

)

balrajahlawat
Esteemed Contributor

Re: Nested IF Statements

Did you check this, clean explanation of Bucket with multiple IF statement?

Buckets

vikasmahajan
Honored Contributor III

Re: Nested IF Statements

IF( Condition  , True, If( Condition , True) )  Hope this helps.


vikas

Not applicable

Re: Nested IF Statements

hi  IF(material4='TAB','TAB',IF(material4='SMP','SMP','REL')) AS REL4, bjut its working fine i need to reflet this  material4 to REL4.

Not applicable

Re: Nested IF Statements

Hi

Please try this expression .

If( [Total Score] > 99.99, 'A',

        If([Total Score] <=99.99 and [Total Score] >=95),'B',

            If([Total Score] <95 and [Total Score] >=90,'C','D')))

                                       

Not applicable

Re: Nested IF Statements

Is there a more efficient method to nested if statements?

In Excel VBA I would use the "Case Select" function.  Is there something similar in Qlikview?

nithya123
New Contributor II

Re: Nested IF Statements

If( [Total Score] > 99.99, 'A',

        If([Total Score] <=99.99 and [Total Score] >=95),'B',

            If([Total Score] <95 and [Total Score] >=90,'C','D'))

Not applicable

Re: Nested IF Statements

How would I nest the IF statements using the following script?

IF([Expenditure Type]='FB, Classified Staff','FB',)

IF([Expenditure Type]='FB, Univ Staff,'FB',)

IF([Expenditure Type]=’Awards & Prizes (Cash)’,’Reward &  Recognition’,)

IF([Expenditure Type]= 'Emp, Recognition Awrd-Non Txbl','Reward  & Recognition',)

IF([Expenditure Type]= 'Employee, Recognition Awards','Reward  &  Recognition',)

IF([Expenditure Type]= ‘Eq Capital Network Servers’,'Hardware’,)

nithya123
New Contributor II

Re: Nested IF Statements

you have to nested if statement for this expression

if statement contains comma (,) is represented by "else" part .

In your else part put after comma.

Community Browser