Exclude Value

[shiveshsingh]

I want to exclude one value in Straight Table

what is the error on below set analysis in Expression part.

({<Column-={'Country'}>})

[trdandamudi]

Looks good to me. What is the error you are getting and can you share a small sample ?

[sunny_talwar]

Set analysis doesn't look wrong, but how you are using it? Something like this?

Sum({<Column -= {'Country'}>} Measure)

[vishsaggi]

IS your Country a value or a field name here? What is your full expression you are using?

[shiveshsingh]

But country is text, how come sum will help here?

[sunny_talwar]

Is this a dimension or expression?

[Anil_Babu_Samineni]

Can you show image atleast?

[shiveshsingh]

Expression

[Anil_Babu_Samineni]

Then Sunny's solution should work. And make we need to type same as in DB. Qlikview is Case Sensitive

[Akina0929]

Hi,

may be it helps try this,

   create calculate dimension

     =if(country<>'india',country)

and check the option >>properties>>>dimensions >>supress when value is null