Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
prabhas277
Creator
Creator

only function

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

6 Replies
tresesco
MVP
MVP

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

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

its_anandrjs
Champion III
Champion III

Hi,

Try this ways

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


In bold use field name at least there.


Regards

Anand

Anonymous
Not applicable

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
Master III
Master III

If you need to know how to use  Only

How to use - Only()

jagan
Partner - Champion III
Partner - Champion III

Hi,

Try like this

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


Hope it helps you.


Regards,

Jagan.

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Hi,


Try this>>>

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


Regards,

Nagarjuna