Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
mardic9618
Contributor
Contributor

Meaning of asterisk (*) in a set expression

Apologies if this question was asked before. 

I am struggling find resources as to how asterisk (*) operator works in a set expression. E.g.:

=sum( {<QPermID={"AM0425_R*"}, any_col)

 

From regex and most other languages i know * stands for any character. Is this the case here?

 

 

Labels (1)
4 Replies
tresesco
MVP
MVP

Yes.

GabrielFonsecaz
Contributor II
Contributor II

The asterisk means sometimes that you can fill up with a random character the field you want. And 'ALL'

Like the examples below: 

Supply: 

Load * Inline

Factory,

Order,

Adress,

Country 

From Lib [my_files/supply*.qvd] (qvd); 

It will consider any letter after supply to load the file you want. The condition you order was just the file name starting with  'supply'.

or maybe

Supply: 

Load * 

From Lib [my_files/supply*.qvd] (qvd); 

It will load all the fields of the file you choose! 
 
Am i being clear? Guess not, but i tried my best.  

Clever_Anjos
Employee
Employee

Your expression means 

sum everything that QpermitId starts with AM0425_R