Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Try GetCurrentSelections() instead
Try this:
If(GetPossibleCount(dim1) > 0 or GetSelectedCount(dim1) > 0, Concat(dim1, ', '))
or may be just -> Concat(dim1, ', ')
use this as chart window Title
=CONCAT({<dim1 = p(dim1)>}DISTINCT dim1,', ')
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