topic What does '*?' mean inside Set Analysis? in App Development

What does '*?' mean inside Set Analysis?

jblomqvist — Tue, 25 Sep 2018 12:20:13 GMT

Hi,

If you have Country={'*?'} as set analysis, what does '*?' mean please?

And what does Country={'*'} mean?

And finally if it is, Sum({$-<Country={'*?'}>}Sales) what does this mean?

Re: What does '*?' mean inside Set Analysis?

petter — Tue, 25 Sep 2018 12:32:19 GMT

You can read about what wildcards mean here:

https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/Selections/SelectionsToolbar/search-selections.htm

Using wildcards in a search in a set expression should be exactly the same - so even if the documentation is for how you use wildcards interactively it does apply for set expressions too.

Note that searches in all the newer releases of Qlik Sense need to use double quotation marks to work. You have examples with single quotation marks which works in olde Qlik Sense versions but not the newer ones...

Re: What does '*?' mean inside Set Analysis?

juraj_misina — Tue, 25 Sep 2018 12:51:33 GMT

If you have Country={'*?'} as set analysis, what does '*?' mean please?

"*?" means any non-empty string (* means string of any lenght, ? means one character).

And what does Country={'*'} mean?

This basicaly means any value in Country field (including empty strings, but not null values!)

And finally if it is, Sum({$-<Country={'*?'}>}Sales) what does this mean?

I'm not 100% sure about this one, this would sum Sales for current selections (the $ sign) excluding all records with value in Country field (-<Country={'*?'}>), so in the end it could consider all records for current selections where Country=null.

Re: What does '*?' mean inside Set Analysis?

jblomqvist — Tue, 25 Sep 2018 13:03:05 GMT

Hi Juraj,

What if it was written as {'?*'}

I switched the ? to be in front of the * from my original example.

Re: What does '*?' mean inside Set Analysis?

juraj_misina — Tue, 25 Sep 2018 13:10:36 GMT

The meaning is exactly the same. ? and * are both wildcards where

"?" means exactly 1 character (e.g. Country = 'S' or Country = 'C')

"*" means any number of characters (e.g. Country ='S' or Country = 'C' or Country = 'Slovakia' or Country = '')

If you want to make sure that value Country field contains at least one character, then you can use "*?" or "?*". They are basically the same, because they mean "any number of characters followed by exactly one character" and "exactly one character followed by any number of characters" respectively.