Set analysis

[zhaohaifeng]

Hi Folks,

One question regarding set analysis and variable need your help.

Sometimes we need to add = before variable for set analysis, sometimes we cant add=. So my concern is that what condition need we add = and when we dont need.

For example below:

have=: Sum({<Time_key={=$(v_defaultdate)}>}Sales)

dont have =:Sum({<Time_key={$(v_defaultdate)}>}Sales)

Thanks for your help in advance.

Best Regards,

Haifeng

[brunobertels]

Hi

If your variable store an interger or string ( Eg '220' or 'New York') you Don't need = sign

If your variable is a mesure ,(Eg sum(Sales) )  then the variable need to be evaluate , therefor you need an equal sign

Bruno

[marcus_sommer · Accepted solution]

Take a look here: The Little Equals Sign

- Marcus