topic Re: Exclude Value in QlikView

Exclude Value

shiveshsingh — Wed, 25 Nov 2020 16:16:04 GMT

I want to exclude one value in Straight Table

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

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

trdandamudi — Sun, 14 May 2017 10:57:20 GMT

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

sunny_talwar — Sun, 14 May 2017 14:29:44 GMT

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

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

vishsaggi — Sun, 14 May 2017 14:44:05 GMT

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

shiveshsingh — Sun, 14 May 2017 14:52:23 GMT

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

sunny_talwar — Sun, 14 May 2017 15:05:35 GMT

Is this a dimension or expression?

Anil_Babu_Samineni — Sun, 14 May 2017 16:15:10 GMT

Can you show image atleast?

shiveshsingh — Mon, 15 May 2017 15:43:57 GMT

Expression

Anil_Babu_Samineni — Mon, 15 May 2017 16:37:55 GMT

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

Akina0929 — Tue, 16 May 2017 04:59:03 GMT

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

sunny_talwar — Fri, 19 May 2017 11:34:32 GMT

Can you share a sample where this isn't working