topic Re: only function in QlikView

only function

prabhas277 — Fri, 10 Apr 2015 05:56:26 GMT

hi to all,

i have one list box called as Names. now my aim is i want get only one value in the in the chart..i am trying like this but i cant get it

Only({<Name='1-Rock Roll'>}) give me what is the correct synario..

regards

suresh

tresB — Fri, 10 Apr 2015 06:06:20 GMT

In the chart dimension, take the filed Names, and in the expression use set analysis like:

Sum({<Name='1-Rock Roll'>} Amount)

its_anandrjs — Fri, 10 Apr 2015 06:08:03 GMT

Hi,

Try this ways

Only({<Name='1-Rock Roll'>} [Field Name Here] )

In bold use field name at least there.

Regards

Anand

Anonymous — Fri, 10 Apr 2015 06:09:58 GMT

use if you want to do it in list box you can use expression

if (Name='1-Rock Roll',Name)

if you want to sum in chart for one name you can use calculated dimension and use above expression.

and in expression use sum(sales)

Thanks

BKC

robert_mika — Fri, 10 Apr 2015 06:15:59 GMT

If you need to know how to use Only

jagan — Fri, 10 Apr 2015 06:18:33 GMT

Hi,

Try like this

=Only({<Name={'1-Rock Roll'}>} Name)

Hope it helps you.

Regards,

Jagan.

nagarjuna_kotha — Fri, 10 Apr 2015 06:21:55 GMT

Hi,

Try this>>>

Only({<Name='Rock Roll'>})

Regards,

Nagarjuna