Discussion board where members can get started with Qlik Sense.
I have some question expression in Qlik Sense,
From attached table, I wanna get Qty from last stock (last date).
I'm using this formula in QlikView :
Expression is no problem in QlikView (although still visible red line, maybe error) , until I copied to Qlik Sense.
Expression doesn't work in qlik sense, no value from formula.
Anyone can help me..?
Go to Solution.
Check this out:
Double quotes will make difference here.
Thank you Thiago, it's worked for me..!!
Do you can explain, when we must use single quotes or double quotes in expressions?
As you can see follow this link - Re: Set analysis difference between single quote and double quote
Double quotes: Case insensitive search where * and ? are interpreted as wildcards
Single quotes: Case sensitive string match where *, ?, =, > and ~ all are treated as any characters
In another word, single quotes should denote literals, and double quotes should initiate a search.
A Primer on Set Analysis