topic Re: Ignore values from feilds in QlikView

Ignore values from feilds

anuradhaa — Wed, 23 Jul 2014 06:02:36 GMT

Hi i have a field called country,

It has lot of values A,B,C,.. and don't know the exact list of values and it is continually growing.

I have a bar chart shows sales by month,Country

I don't want to display Country 'C' in this graph. But i want to load all data(can't elininate it in the script)

So i have use set analysis, but doesn't work

=sum({<COUNTRY-={"C"}>} SALESCOUNT)

please tell me how to fix this issue

Thanks

Re: Ignore values from feilds

senpradip007 — Wed, 23 Jul 2014 06:09:12 GMT

In Script try like

Load

....

From <Table> where Country <> 'C';

Re: Ignore values from feilds

anuradhaa — Wed, 23 Jul 2014 06:11:14 GMT

I can't ignore this value from the script, i want in other charts

Thank You

Re: Ignore values from feilds

sasikanth — Wed, 23 Jul 2014 06:12:23 GMT

try some thing like below

=sum({<COUNTRY={'*'}-{'C'}>} SALESCOUNT)

Re: Ignore values from feilds

anuradhaa — Wed, 23 Jul 2014 06:14:14 GMT

Thanks,

I have tried it too, but there chart doesn't behave according to selections.

Thanks

Re: Ignore values from feilds

PradeepReddy — Wed, 23 Jul 2014 06:14:59 GMT

Try like this...

=sum({<COUNTRY-={'C'}>} SALESCOUNT)

Re: Ignore values from feilds

anuradhaa — Wed, 23 Jul 2014 06:23:16 GMT

yes, That's the thing that i have tried.But when i use that it shows red underlines after equal sign.

Re: Ignore values from feilds

sasikanth — Wed, 23 Jul 2014 06:23:49 GMT

try to upload your sample file,,,,,

Re: Ignore values from feilds

Anonymous — Wed, 23 Jul 2014 06:32:17 GMT

HI,

Try it

=sum({<COUNTRY != {'C'}>} SALESCOUNT)

Re: Ignore values from feilds

anuradhaa — Wed, 23 Jul 2014 06:33:11 GMT

Hi,,

This is sample qvw.

Please remove County "C" from the chart

Re: Ignore values from feilds

anuradhaa — Wed, 23 Jul 2014 06:34:29 GMT

No, not works

Re: Ignore values from feilds

Anonymous — Wed, 23 Jul 2014 06:34:42 GMT

Red underlines is a bug. But it should say "Expression OK" and calculation should work. If not, try checking spellings of your fields.

Re: Re: Ignore values from feilds

sasikanth — Wed, 23 Jul 2014 06:36:05 GMT

PFA

Re: Ignore values from feilds

anuradhaa — Wed, 23 Jul 2014 06:37:22 GMT

Oh... Grate.

It works.....

Thank You so much

Re: Ignore values from feilds

anuradhaa — Wed, 23 Jul 2014 06:41:03 GMT

But, This doesn't solve my issue completely.

Because, when i put it and select selections chart doesn't behave arroding to selections.

Thanks

Re: Ignore values from feilds

anuradhaa — Wed, 23 Jul 2014 06:51:32 GMT

HI,

I have used if statement and solve my issue.

Thank You for your help

Re: Ignore values from feilds

Anonymous — Wed, 23 Jul 2014 06:51:36 GMT

Pls try this

=sum(sales) - sum({<COUNTRY={'C'}>} sales)

Regards,

Krishna

Re: Ignore values from feilds

sasikanth — Wed, 23 Jul 2014 06:51:40 GMT

Go with calculated DIm,

like if(CNTRY<>'C',CNTRY) and supress null values,

then try to make selections

Re: Ignore values from feilds

SunilChauhan — Wed, 23 Jul 2014 06:53:17 GMT

may be you your

sum({$<COUNTRY-={"C"}>} SALESCOUNT)

or what exaclty you want. plz share sample

Re: Ignore values from feilds

anuradhaa — Wed, 23 Jul 2014 06:55:58 GMT

Already shared a sample, anyway i have solved my issue by using if statement. Thank you for your help