topic Re: Dynamic title in QlikView

Dynamic title

rcorcoran — Mon, 26 May 2014 11:48:25 GMT

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)

Re: Dynamic title

Gysbert_Wassenaar — Mon, 26 May 2014 12:00:16 GMT

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, ' / ')

Re: Dynamic title

Mon, 26 May 2014 12:02:41 GMT

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

Re: Dynamic title

rcorcoran — Mon, 26 May 2014 12:09:51 GMT

thanks to all and to Chris that is great.