topic Re: set modifier expression error ! in QlikView

set modifier expression error !

Tue, 31 Jan 2012 14:05:17 GMT

Hi Community,

i have this formula on an simply texfieldobject:

=num(
    100 - (
        Count(DISTINCT{ < FIELDVALIDATION={'invalid'} > } [HEL_DATA_Flight ID]) /
        Count(DISTINCT [HEL_CAMPAIGN_Flight ID]) * 100),
        '0,000'
    ) & ' %'

this works very fine. But now i want to expand the condition from

FIELDVALIDATION={'invalid'}

FIELDVALIDATION = {'invalid'} AND NOT ([HEL_CAMPAIGN_Flight] like '*locker*')

in this case i get a errormessage from qlikview ( Error in set modifier expression ) Any Idea how can i implement it anyway ?

Thank you very much

Regards,

expression error !

Tue, 31 Jan 2012 14:11:08 GMT

When you have just the second part in the condition is it working ?? NOT ([HEL_CAMPAIGN_Flight] like '*locker*')

expression error !

Tue, 31 Jan 2012 14:13:29 GMT

Try something like that

{ < FIELDVALIDATION={'invalid'} > - < [HEL_CAMPAIGN_Flight]={'*locker*'} > }

set modifier expression error !

Tue, 31 Jan 2012 14:17:55 GMT

it doesnt work with

NOT ([HEL_CAMPAIGN_Flight] like '*locker*')

Re: set modifier expression error !

Tue, 31 Jan 2012 14:19:34 GMT

hi,

it seems to be better now without an errormessage . But the calculated value from this formula is wrong !

It must be 99,xxx %. But the modified formula shows 100 %

set modifier expression error !

Tue, 31 Jan 2012 14:22:26 GMT

You probably can solve that un number sheet (properties) and show X decimals

set modifier expression error !

Tue, 31 Jan 2012 14:27:24 GMT

What about

{ < FIELDVALIDATION={'invalid'}, [HEL_CAMPAIGN_Flight]-={'*locker*'} > }

Re: set modifier expression error !

Tue, 31 Jan 2012 14:32:01 GMT

Thats it

you are right. Instead of 3 points e.g 0,000 , i tried it with 4 points eg. 0,0000.

Thank you very much

Re: set modifier expression error !

Tue, 31 Jan 2012 14:34:04 GMT

Thats also works

Thank you too

Re: set modifier expression error !

Tue, 31 Jan 2012 14:36:24 GMT

Thank you for your help guys

Best Regards,

Hon