Difference between column and only(column)

[#1]

Hi,

Can anyone let me know what is the difference between

Columnname and Only(Columnname) when used in expression

Thanks.

[CELAMBARASAN]

Both are same.

In only() you can use set analysis or if condition to restrict some rows not to display.

[tresesco]

If you write in expression =Columnname, qv takes as =Only(Columnname) internally, if you explicitly write that, qv doesn't have to treat it differently internally, otherwise both are same i believe.

When you explicitly write with Only(), you have the advantage of using aggregation function.

[#4]

Thanks can you please post an example expression with only() by using set analysis.

[MayilVahanan]

HI

PFA

[CELAMBARASAN]

Sure.

[#7]

Thanks and in the same manner if I have a column with NULL values and data.

In that case f I need to get only data values skipping NULL values means is it possible with only()?

[MayilVahanan]

HI

Yes

= Only({<Product = {'*'}>} Sales)

In this, its skips null value

[CELAMBARASAN]

Yes. You could use

Only({<FieldName={'*'}>} FieldName) - it excludes null

[#10]

Thanks and is it possible to use the same in dimension?