Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can anyone let me know what is the difference between
Columnname and Only(Columnname) when used in expression
Thanks.
Both are same.
In only() you can use set analysis or if condition to restrict some rows not to display.
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.
Thanks can you please post an example expression with only() by using set analysis.
HI
PFA
Sure.
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()?
HI
Yes
= Only({<Product = {'*'}>} Sales)
In this, its skips null value
Yes. You could use
Only({<FieldName={'*'}>} FieldName) - it excludes null
Thanks and is it possible to use the same in dimension?