topic Re: Set analysis - passing search strings in QlikView

Set analysis - passing search strings

Anonymous — Mon, 16 Feb 2015 12:00:15 GMT

I read in one of the Qlikview materials that it is possible to provide 'Sear Strings' as parameters in a set analysis. For eg

sum ({$<Field1 = {"search string"}>}metric).

Can one of you please provide a sample for such usage?

Many Thanks in advance!

Re: Set analysis - passing search strings

Mon, 16 Feb 2015 12:04:57 GMT

sum ({$<Field1 = {'*search string*'}>}metric)

Re: Set analysis - passing search strings

maxgro — Mon, 16 Feb 2015 12:16:07 GMT

some example from QlikView online help; I suggest to read the help for more examples

sum( {$<~Ingredient = {“*garlic*”}>} Sales )
returns the sales for current selection, but with a forced exclusion of all Ingredients containing the string ‘garlic’.

sum( {$<Year = {“2*”}>} Sales )
returns the sales for current selection, but with all years beginning with the digit “2”, i.e. most likely year 2000 and onwards, selected in the field “Year”.

sum( {$<Year = {“2*”,”198*”}>} Sales )
as above, but now also the 1980:s are included in the selection.

sum( {$<Year = {“>1978<2004”}>} Sales )
as above, but now with a numeric search so that an arbitrary range can be specified.

Re: Set analysis - passing search strings

Anonymous — Mon, 16 Feb 2015 12:43:55 GMT

Got it Massimo....think i had used it before knowing it...many thanks for the reply