topic Re: How to exclude strings from the field using buttons in QlikView

How to exclude strings from the field using buttons

AH — Wed, 19 Nov 2014 20:12:21 GMT

I want to exclude these two string values using the button. I was trying to use this expression but its not working.

"("& concat({<ServiceOrderDesc-={"SPARE PARTS ORDER","spare part needed"}>} Distinct ServiceOrderDesc, '|')& ")'

Its not working. Anyone help me please!

Re: How to exclude strings from the field using buttons

JonnyPoole — Wed, 19 Nov 2014 20:58:06 GMT

try this

='(' & Concat( {<ServiceOrderDesc=-{'SPARE PARTS ORDER','spare part needed'}>} distinct '"' & ServiceOrderDesc & '"','|') & ')'

it will create values like this:

("Value1","Value2")

..excluding the 2 you wrote out

The double quotes are used in case their are spaces or other special characters in the Values

Re: How to exclude strings from the field using buttons

AH — Wed, 19 Nov 2014 21:04:42 GMT

Hey Jonathan,

I appreciate your help but its not working.

Thanks,

Shan

Re: How to exclude strings from the field using buttons

JonnyPoole — Wed, 19 Nov 2014 21:16:12 GMT

Oh thats ok. The expression editor has a bug on the highlighter when you use -= syntax in SET ANALYSIS. You'll notice it says 'ok' right above. Trying hitting OK and let me know the results.

Re: How to exclude strings from the field using buttons

AH — Wed, 19 Nov 2014 21:20:07 GMT

It still doesnt work.

Thanks,

Shan

Re: Re: How to exclude strings from the field using buttons

JonnyPoole — Wed, 19 Nov 2014 21:24:19 GMT

Here is the sample off my data.

If you have an app to share i can apply the same to yours.

Re: How to exclude strings from the field using buttons

AH — Wed, 19 Nov 2014 21:41:49 GMT

Jonathan,

Thank you very much. Its working now.

Shan

Sorry, I was using an excel file and it was working but now i am using database and its not working now.

Thanks,

Shan