topic Re: In Which situation we will use only() in QlikView

In Which situation we will use only()

d_koti24 — Fri, 14 Aug 2015 11:11:28 GMT

Hi all,

In Which situation we will use only(),can any one explain with sample scenario.

regards,

Re: In Which situation we will use only()

mohammadkhatimi — Fri, 14 Aug 2015 11:13:17 GMT

Hi,

When there is one to one relation ship, we can use only function.

In simple word,

Table:

LOAD * Inline [

Dim1, Dim2, Value

A, India, 10

B, USA, 30

];

If we use Dim1 in textbox without any selection , it display null value for both

=Only(Dim1) or Dim1

If We select any value in Dim1, it display the Value in textbox.

If we need to use "Set Analysis", in that case we can use Only() function.

Only({<Dim2 = {'India'}>}Dim1) display A.

only(expression )

If expression over a number of records, as defined by a group by clause, contains only one numeric value, that value is returned. Else, NULL is returned.

Re: In Which situation we will use only()

sunny_talwar — Fri, 14 Aug 2015 11:14:35 GMT

Just created an example for Only() today. Have a look here: Only

Re: In Which situation we will use only()

awhitfield — Fri, 14 Aug 2015 11:18:51 GMT

Hi Koti,

Help description of Only:

only([{set_expression}][ distinct ] [ total [<fld {, fld}>]] expression)

If expression or field iterated over the chart dimension(s) contain one single value, that value is returned, else NULL is returned. Only can return numeric values as well as text values.

Examples:

only( Sales )

only( Price*Quantity )

only( total Salesman )

HTH- Andy

Re: In Which situation we will use only()

d_koti24 — Fri, 14 Aug 2015 13:12:33 GMT

Still i am in confusion? what is the necessary of use only() in the above example..instead of that if i take dim2 in listbox..then that time also it's working fine..

Re: In Which situation we will use only()

Peter_Cammaert — Fri, 14 Aug 2015 13:26:15 GMT

Only() - although it appears to be an extremely straightforward function - is actually a very advanced aggregation function that will save your day more than once. If the use of Only() isn't apparent to you yet, don't worry. You do not need it. You have a solution but no corresponding problem, so just ignore it for the time being.

One of my preferred uses for Only() is whenever I need to apply set analysis on very few values to select a single one. Only() is the only function that let's you pick a single value from a range by simply using set analysis.

Peter

Re: In Which situation we will use only()

maxgro — Fri, 14 Aug 2015 13:41:21 GMT

and a detailed explanation

The Only Function

How to use - Only()