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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Selection name should be display on top of chart?

Hi Folks ,

I have dim1 ,dim2 and sal fields,

I have created chart like    dim1 is my dimension and sum(sales) is my expression

my selection should come as chart title

if I give getfieldselctions(dim1) then I am getting .

but my req is when I click on dim2  associated data will select in dim1 in that case my chart will populate for associated data only

when I make selections in dim2 , associated data of dim1 should come as chart title

load * inline [

dim1,dim2,sales

india,bang,100

pakisthan,,xyz,200

];

my chart dim1 is my dimension and sum(sales) is my expression

when I click on xyz even my chart still show pakisthan ?

4 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try GetCurrentSelections() instead


talk is cheap, supply exceeds demand
sunny_talwar

Try this:

If(GetPossibleCount(dim1) > 0 or GetSelectedCount(dim1) > 0, Concat(dim1, ', '))

or may be just -> Concat(dim1, ', ')

MK_QSL
MVP
MVP

use this as  chart window Title

=CONCAT({<dim1 = p(dim1)>}DISTINCT dim1,', ')

engishfaque
Specialist III
Specialist III

Dear CommonQlik,

For dynamic chart title, use listed below express:

=$(= '[' & ONLY($Field) & ']')

For, Possible and Exclude Set Analysis. Please go through listed below resource,

P() and E() in set analysis expression

Kind regards,

Ishfaque Ahmed