Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

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