topic Re: filtering 2 strings in the chart level???? need help please????? in QlikView

filtering 2 strings in the chart level???? need help please?????

Mon, 02 Jun 2014 06:57:10 GMT

Hi all,

Please can someone help me with the below issue??????????????????????

I have to filter strings from a field and put it as expression in the chart.I was able to do it for one string using maxstring function.how do I combine both the condition in maxstring????? or any other method present???? please help.

The 2 strings to be filtered are :

1)"Past Expiration Out-Of-The-Money: Option Value"

2)"Past Expiration In-The-Money: Option Value"

maxstring({<fee_type-={'Past Expiration In-The-Money: Option Value'}> }fee_type)

I have attached a sample file,in "sheet 3"where a field fee_type is selected.here the first 2 strings in them beginning from "Past" should be filtered in the table and hence only the values starting from "strike " should be seen in the table.

Re: filtering 2 strings in the chart level???? need help please?????

tresB — Mon, 02 Jun 2014 07:02:38 GMT

Try with wildchar - '*' , like:

=maxstring({<fee_type-={'Past*'}> }fee_type) // 'Past*'

Re: filtering 2 strings in the chart level???? need help please?????

its_anandrjs — Mon, 02 Jun 2014 07:04:09 GMT

You can try with

maxstring({<fee_type-={'Past Expiration In-The-Money: Option Value', 'Past Expiration Out-Of-The-Money: Option Value' }> }fee_type)

Re: filtering 2 strings in the chart level???? need help please?????

Mon, 02 Jun 2014 07:06:36 GMT

Hi,

thanks for the response.

This solution works only if I click on the field where these strings are present,but when I do a clear in the application it doesnt work..... so how do I permanently filter out this???

Re: Re: filtering 2 strings in the chart level???? need help please?????

tresB — Mon, 02 Jun 2014 07:18:54 GMT

Try :

=maxstring({<fee_type=- {'Past*'}> }fee_type) // neg sign after '=' sign

Re: Re: Re: filtering 2 strings in the chart level???? need help please?????

Mon, 02 Jun 2014 07:47:32 GMT

Hi Tresesco,

thanks this solution helped in obtaining the result as required.One doubt ,cant this be used in the script itself,because whenever I used maxstring expression before in script the load used to stop abruptly just telling execution failed .

In case it is possible,can you please guide me as where I can place this condition in script???I have attached the sample.

Re: Re: filtering 2 strings in the chart level???? need help please?????

tresB — Mon, 02 Jun 2014 07:51:59 GMT

In the script, try like:

Load

field1,

....

free_type

From <> Where Not WildMatch(free_type, 'Past*');

Re: Re: Re: filtering 2 strings in the chart level???? need help please?????

Mon, 02 Jun 2014 08:04:03 GMT

Hi Tresesco,

thanks a lot for ur valuable help.I am learning each time something from ur answers.

I have one peculiar requirement which is like:(lil difficult to explain) I will do it in a new discussion ,please help me out.will post it soon.