topic Re: Subselects in Qlik Sense Desktop Formel editor in App Development

Subselects in Qlik Sense Desktop Formel editor

Thu, 05 Nov 2015 14:56:21 GMT

Hi there,

I already had some related issues with these kind of sorting, but I can't find a way to get this one going.

So here is my Problem:

I've got a list (e.g. a table with the alphabet a-z) and now I want to make a Filterfield wich only contains the letters U,F,O.

I would like to have something like this:

if([IDCode] = U,[IDCode])

or if([IDCode] = F,[IDCode])

or if([IDCode] = O,[IDCode])

but this doesn't seem to work. I just want the list to show these 3 lettern and not grey out all the others.

Re: Subselects in Qlik Sense Desktop Formel editor

Chanty4u — Thu, 05 Nov 2015 16:52:16 GMT

use wildmatch

Re: Subselects in Qlik Sense Desktop Formel editor

Fri, 06 Nov 2015 13:43:19 GMT

Thanks, I've currently set it to something like this:

if(	WILDMATCH([CostCarriers.IdCode],'KH ')

but I'm getting results with "KH private" too and want to remove them from the list now. is this possible with Wildmatches too?

Re: Subselects in Qlik Sense Desktop Formel editor

JonnyPoole — Fri, 06 Nov 2015 22:04:56 GMT

if([IDCode] = U [IDCode] = F or [IDCode] = O,[IDCode])

Re: Subselects in Qlik Sense Desktop Formel editor

JonnyPoole — Fri, 06 Nov 2015 22:05:41 GMT

oops..

if([IDCode] = U or [IDCode] = F or [IDCode] = O,[IDCode])

Re: Subselects in Qlik Sense Desktop Formel editor

rwunderlich — Fri, 06 Nov 2015 23:00:23 GMT

How about:

=aggr(only({<IDCode={U,F,O}>}IDCode),IDCode)

-Rob

Re: Subselects in Qlik Sense Desktop Formel editor

Mon, 09 Nov 2015 07:28:32 GMT

Thank you Rob,

sureshqv's answer works too, but yours is a little bit better, because it only uses one line to select multiple records.

I've set it all up and It only shows the results with U,F and O so that's working as expected.

If I use a wildcard on 'O*' I'm getting OE too. is there a way to exclude records with '*k' ?

OE is ok, but I don't want 'Oak'

Re: Subselects in Qlik Sense Desktop Formel editor

rwunderlich — Mon, 09 Nov 2015 23:51:17 GMT

You can set up an intersection (*) with a set of exclusions defined by the -= operator. This is a simple way to create an "AND" criteria on the same field.

=aggr(only({<IDCode={U,F,"O*"}> * <IDCode-={"*k"}>}IDCode),IDCode)

Test qvw attached. Oops. Forgot this was Qlik Sense. Sample qvf attached as well.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com