topic Re: set analysis calculate wrong values for a field in QlikView

set analysis calculate wrong values for a field

Wed, 25 Nov 2015 10:03:34 GMT

Hello,

The values of the field "execution venue code " must be like this ---> (Normal type) :

MIC – XXXX (4 letters characters) or INT – XXXX (4 numerous characters)

I would like calculate the number of wrong values for the thield( execution venue code ) -> which does not correspond to the normal type.

To calculate the number of values does not starting by "INT-" and "MIC-" this expression is working :

count( {1< EXECUTION_VENUE_CODE = {'*'}-{'INT-*', 'MIC-*'} >} EXECUTION_VENUE_CODE)

Now, i want calculate in the same expression the values having more than 8 characters

My question : how i can improve this expression to calculate the number of values having more than 8 caracters ?

NB : to calcluate the number of values for the field having more than 8 characters may be done like this :

Count( if (Len(EXECUTION_VENUE_CODE)>8, EXECUTION_VENUE_CODE))

Thanks in advance,

Regards,

Mark_Little — Wed, 25 Nov 2015 10:22:13 GMT

Hi,

I would do this in script, create flag.

if (Len(EXECUTION_VENUE_CODE)>8, 1,0) as LengthFlag

Then

Count({<LengthFlag={1}>}EXECUTION_VENUE_CODE)

Mark

Wed, 25 Nov 2015 10:23:12 GMT

can u pls give the sample data

PrashantSangle — Wed, 25 Nov 2015 10:25:53 GMT

Hi,

try like

Count(if(len(Execution_Venue_code)>8 and not wildmatch(Execution_Venue_code,'INT-*','MIC-*'),Execution_Venue_code))

Regards

tresB — Wed, 25 Nov 2015 10:49:14 GMT

Try like:

count( {1< EXECUTION_VENUE_CODE = {'*'}-{'INT-*', 'MIC-*'} > - < EXECUTION_VENUE_CODE = {"=Len(EXECUTION_VENUE_CODE)<=8"} >} EXECUTION_VENUE_CODE)

Wed, 25 Nov 2015 14:45:31 GMT

Hello,

Thank you very much for your answers.

you gave me the idea. So the correct expression is :

= count(if (not wildmatch(EXECUTION_VENUE_CODE,'INT-????','MIC-????'),EXECUTION_VENUE_CODE ))

Thanks again