topic Re: Not Equal to Expression in QlikView

Not Equal to Expression

ryanfoster84 — Wed, 02 Sep 2015 10:20:45 GMT

hi i have a variable and it calculates ADV for the latest quarter and it looks like this:

=sum(

{$<

[Quarter] = ,

[Quarter Number] = {$(vMaxQuarter)},

[Opportunity Age] = ,

[Month Name] = ,

[Account Manager Full Name] = ,

[Year] = {$(vPreviousYear)},

[Country] = {"United States","UNKNOWN"},

Volume)

Max(total

{$<

//[Month] = {$(vMaxMonth)},

[Quarter Number] = {$(vMaxQuarter)},

//[Month Name] =,

[Year] = {$(vPreviousYear)}

[Business Days QTD])

but i need country to be NOT EQUAL TO United States but am struggling on how to do it. any help would be great

Re: Not Equal to Expression

sunny_talwar — Wed, 02 Sep 2015 10:23:06 GMT

May be this:

=Sum(

{$<[Quarter] = ,

[Quarter Number] = {$(vMaxQuarter)},

[Opportunity Age] = ,

[Month Name] = ,

[Account Manager Full Name] = ,

[Year] = {$(vPreviousYear)},

[Country] -= {'United States'}>}

Volume)

Max(total

{$<

//[Month] = {$(vMaxMonth)},

[Quarter Number] = {$(vMaxQuarter)},

//[Month Name] =,

[Year] = {$(vPreviousYear)}

[Business Days QTD])

Update: This will exclude 'United States' from the numerator expression. Is this what you want?

Re: Not Equal to Expression

ryanfoster84 — Wed, 02 Sep 2015 10:28:37 GMT

let me test now

Re: Not Equal to Expression

sasiparupudi1 — Wed, 02 Sep 2015 10:29:12 GMT

as per your condition,

[Country] = {"United States","UNKNOWN"}

you are indicating that the country should be only united states and Unknown.

if you do not want united states as a country , that means you only want the countries that are unknown?

if you want to exclude certain countries, you could do

[Country] ={'*'}-{'United States'}

hth

Sasi

Re: Not Equal to Expression

ryanfoster84 — Wed, 02 Sep 2015 10:35:59 GMT

hey both answers are correct many thanks