topic Re: Re: Difference between column and only(column) in QlikView

Difference between column and only(column)

Thu, 17 Oct 2013 11:55:01 GMT

Hi,

Can anyone let me know what is the difference between

Columnname and Only(Columnname) when used in expression

Thanks.

Re: Difference between column and only(column)

CELAMBARASAN — Thu, 17 Oct 2013 11:58:54 GMT

Both are same.

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

Re: Difference between column and only(column)

tresB — Thu, 17 Oct 2013 11:59:04 GMT

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.

Re: Difference between column and only(column)

Thu, 17 Oct 2013 12:00:31 GMT

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

Re: Re: Difference between column and only(column)

MayilVahanan — Thu, 17 Oct 2013 12:03:40 GMT

PFA

Re: Re: Difference between column and only(column)

CELAMBARASAN — Thu, 17 Oct 2013 12:08:13 GMT

Sure.

Re: Difference between column and only(column)

Thu, 17 Oct 2013 12:21:46 GMT

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()?

Re: Difference between column and only(column)

MayilVahanan — Thu, 17 Oct 2013 12:25:02 GMT

Yes

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

In this, its skips null value

Re: Difference between column and only(column)

CELAMBARASAN — Thu, 17 Oct 2013 12:25:04 GMT

Yes. You could use

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

Re: Difference between column and only(column)

Thu, 17 Oct 2013 12:29:11 GMT

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

Re: Difference between column and only(column)

CELAMBARASAN — Thu, 17 Oct 2013 13:12:44 GMT

Only cannot be used in dimension. It can only be used in expression.

But you can use expression in dimension combined with Aggr

Aggr(If(Not IsNull(FieldName), FieldName), FieldName)

Re: Difference between column and only(column)

Fri, 18 Oct 2013 13:02:57 GMT

Thanks for your answer.