Using functions in set modifiers

[Gang]

Hi ,

Am new to Qliksense. Could anyone help me to understand the set analysis syntex better when it comes to using the functions in modifier.

Here are the expression which I used in KPI chart.

sum({<Year = {"$(=max(Year))"}>}yrprice)

sum({<Product = {"=mid(Product,2,1)='i'"}>}Price)

In first Expression why we have used $() and why it is not in second experience. 

If I change the second experience as per first I didn't get the expected results. 

[lironbaram · Accepted solution]

in the first expression, you are using a simple search for a value 
so the dollar causes the qlik engine to calculate the expression once and use the result for the filtering
In the second expression, you are using qlik smart search, this type of search needs to evaluate the expression for each product alone. hence you are not using $ sign 

[anthonyj · Accepted solution]

Hi,
I'm interested in other's opinions on this, but from what I see in the documentation is that $( ) expansion is calculated just before the expression is calculated. So it is done once and can therefore only return one value. Eg as of this year currently Max(Year) will return 2021.

"=mid(Product,2,1)='i'" resolves row wise passing the value of Product on that line to the function. For example:

Product    Resolving to                           Result

Pie               "=mid('Pie',2,1)='i'"            True

Cake            "=mid('Cake',2,1)='i'"         False

I hope this makes sense and if someone can provide a correction or confirmation that would be great. 

Thanks

Anthony

[Gang · Accepted solution]

Thanks both Anthonyj and Lironbaram . Now I understood the difference. It make sense.