Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

current selections in a chart(urgent)

I want to display all the current slections made on the current sheet in the chart title. How can i do that?

4 Replies
Not applicable
Author

Please check this thread for ways of displaying current selections. That can be done in the chart-title as well.

http://community.qlik.com/qlikviews/1251

Let me know if it helped (or not).

Not applicable
Author

Thanks roberto for the Reply. This app is useful for knowing how current selection works and how it can be displayed? But i want to know the expression, i should write to apply it in my chart's title......

Not applicable
Author

I abbabbabb,

I assume that you know that every expression you can make visible in a textbox can also be placed in the charts title?

For example: put this expression in your chart-title:

='This is the current datetime: '&now()

>>Likewise you can copy/paste the expression used in the app that I gave you the link to.

When you start your chart title with an equal sign ( = ) then you can write any expression you want, with all functions that qlikview has available (like the count of records that are selected etc etc)

(

or to answer more direct: I think you can put the code below in your chart title (pasted from that .qvw and changed a bit)

Expression

='  Current Selections: ' & if(isnull(GetCurrentSelections()), 'Nothing selected', GetCurrentSelections(' | ', ': ', ','))

)

Let me know if this helped

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Please be aware that the link that was posted above has been superseded by this one as part of a site upgrade:

http://community.qlik.com/docs/DOC-4290

Regards,

Steve

http://www.quickintelligence.co.uk/