In expression statement, the use of various kinds of symbols..

[harrywu1]

Hi experts!

During the course of learning expression statement, I found myself a bit confused with the various sybols ( "",'',[],(),{},<>, etc. ), and their usage.  Any recommended reference regarding this?

For example,

1. num( Count({<[ID SCD duplicate]={"=Count([ID SCD duplicate])>1"}>}[ID SCD duplicate]), '# ##0')

2. Sum({$<Year = {$(=Max(Year))}, Month = {'$(=Max(Month))'}>} ActualSold)

In Expression 1.) ={"=Count, { is followed by ", to start the identifier condition.

However, in Expression 2.) ={'$(=Max, { is followed by ', to start the identifier condition.

And, what is [ ] for?  I thought, [ ] was to quote the existing expressions into the new expression.  But is it correct?

Can I find any related resource/reference on this?

Thanks!

[Anil_Babu_Samineni]

If i understand correct, the square bracket apply where field is not a single word like empno is the single word where [emp no] needs to be cover because qlik can capture as 2 words..

[harrywu1]

2. Sum({$<Year = {$(=Max(Year))}, Month = {'$(=Max(Month))'}>} ActualSold)

Another finding is that, for the identifier of YEAR, it didn't put ' ' in the identifier expression. But MONTH did.

Could anyone help explain?

(this expression example was what I randomly captured in the forum, which was marked as Correct Answer. So, I assume that worked.)

[Anil_Babu_Samineni · Accepted solution]

There is no finding either you can get it

Sum({$<Year = {'$(=Max(Year))'}, Month = {'$(=Max(Month))'}>} ActualSold)

Sum({$<Year = {$(=Max(Year))}, Month = {$(=Max(Month))}>} ActualSold)

In latest versions, There are small changes you must need like Quotes in Set Analysis

[harrywu1]

Hi Anil,

The article you provided about Double quotes & Single quotes really explained it mostly!  Thanks!

So far I think there's nothing better than your response.

I will keep my set expression going on with the tradition, to see if any confusion again.