Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

rcorcoran
Contributor

Dynamic title

Hi

I want to put this in a chart title to show the Hospital group and the year that is selected and it works fine but I also want it to show if 'Hospital' is picked as a selection so either hospital or hospital group will  be selected and the year and then the title should show these

I have tried all sorts of and or expressions but it doesnt seem to work

=GetFieldSelections(HospitalGroup)& ' , ' & GetFieldSelections(ReferredYYYY)

1 Solution

Accepted Solutions
Not applicable

Re: Dynamic title

Hi Rhona,

If i understand well, if Hospital is selected you want hospital name, if not you want Hospital group selected

=if(count(distinct  Hospital)=1,
GetFieldSelections(Hospital)& ' , ' & GetFieldSelections(ReferredYYYY) ,

GetFieldSelections(HospitalGroup)& ' , ' & GetFieldSelections(ReferredYYYY)

)


best regard

Chris

3 Replies

Re: Dynamic title

GetFieldSelections only returns values that are actually selected. As long as there's only one possible value you can use something like =only(HospitalGroup). Otherwise try concat(distinct HospitalGroup, ' / ')


talk is cheap, supply exceeds demand
Not applicable

Re: Dynamic title

Hi Rhona,

If i understand well, if Hospital is selected you want hospital name, if not you want Hospital group selected

=if(count(distinct  Hospital)=1,
GetFieldSelections(Hospital)& ' , ' & GetFieldSelections(ReferredYYYY) ,

GetFieldSelections(HospitalGroup)& ' , ' & GetFieldSelections(ReferredYYYY)

)


best regard

Chris

rcorcoran
Contributor

Re: Dynamic title

thanks to all and to Chris that is great.

Community Browser