Multiple "if" "and" statements

[denvercoker]

Hi all,
I'm still pretty new (about 3 months in) and I have a question about if statements with multiple "and" conditions. I want to write a statement that returns "Flag" when an account has S>1 and when the selected ratio is higher than the ratio of the nation. My code is as follows with a few changes for the sake of confidentiality

=if($(vS) >1 and ($(vCDObsCases))/($(vCDObsCases)+$(vMObsCases)+$(vCAObsCases)+$(vCLObsCases)+$(vCoObsCases)+$(vAbObsCases))>

                        (((sum({<[Measure Name] = {'CD Observed Cases'},H=,Sum5=>}Score)))/

                        ((sum({<[Measure Name] = {'CD Observed Cases'},H=,Sum5=>}Score))+

                        (sum({<[Measure Name] = {'M Observed Cases'},H=,Sum5=>}Score))+

                        (sum({<[Measure Name] = {'CL Observed Cases'},H=,Sum5=>}Score))+

                        (sum({<[Measure Name] = {'CAObserved Cases'},H=,Sum5=>}Score))+

                        (sum({<[Measure Name] = {'Co Observed Cases'},H=,Sum5=>}Score))+

                        (sum({<[Measure Name] = {'Ab Observed Cases'},H=,Sum5=>}Score)))),'Flag', 'Safe')

Where my dimension is H

I'm getting "Flag in some cases and when I see it, it's correct but the other 90% of cases that should be marked as "Flag" are being marked "Safe" by mistake.

[sunny_talwar]

You need to check these links out if you really need our help here:

QlikCommunity Tip: How to get answers to your post?

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

[denvercoker]

Is your reply saying you aren't going to help me because my question isn't formatted a specific way? Is this not the new user section?

[sunny_talwar]

Hahahaha if my intention was not to help you, then I would have never provided you those links. All I am saying is that you need to provide more information in order to get help. Else, it will be difficult (may be impossible) to help with the information provided .

[sasiparupudi1]

What is the difference between

((sum({<[Measure Name] = {'CD Observed Cases'},H=,Sum5=>}Score)))/

                        ((sum({<[Measure Name] = {'CD Observed Cases'},H=,Sum5=>}Score))+

                        (sum({<[Measure Name] = {'M Observed Cases'},H=,Sum5=>}Score))+

                        (sum({<[Measure Name] = {'CL Observed Cases'},H=,Sum5=>}Score))+

                        (sum({<[Measure Name] = {'CAObserved Cases'},H=,Sum5=>}Score))+

                        (sum({<[Measure Name] = {'Co Observed Cases'},H=,Sum5=>}Score))+

                        (sum({<[Measure Name] = {'Ab Observed Cases'},H=,Sum5=>}Score)))

and

$(vCDObsCases))/($(vCDObsCases)+$(vMObsCases)+$(vCAObsCases)+$(vCLObsCases)+$(vCoObsCases)+$(vAbObsCases))?

They both look doing the same operation?

also

(sum({<[Measure Name] = {'CD Observed Cases'},H=,Sum5=>}Score))+

                        (sum({<[Measure Name] = {'M Observed Cases'},H=,Sum5=>}Score))+

                        (sum({<[Measure Name] = {'CL Observed Cases'},H=,Sum5=>}Score))+

                        (sum({<[Measure Name] = {'CAObserved Cases'},H=,Sum5=>}Score))+

                        (sum({<[Measure Name] = {'Co Observed Cases'},H=,Sum5=>}Score))+

                        (sum({<[Measure Name] = {'Ab Observed Cases'},H=,Sum5=>}Score)))

can be written as

(sum({<[Measure Name] = {'CD Observed Cases','M Observed Cases','CL Observed Cases','CA Observed Cases','Co Observed Cases',''Ab Observed Cases'},H=,Sum5=>}Score))

As Sunny says, may be its better if you could post a sample so that we can understand your issue better..