topic Re: How to have only selected fields in a text Title in QlikView

How to have only selected fields in a text Title

Fri, 20 Jul 2012 00:42:37 GMT

Thought of posting this in a new thread. Micheal had answered this one on how to construt titles with all fields.As shown below.

Use concat function:

='My Company Name' & chr(10) & concat(distinct fieldName, ' & ')

The above expression in a text object gives all available fields. How do we get only the green (selected fields only) to be concatenated.

Thanks,

Rodrigues

Anonymous — Fri, 20 Jul 2012 00:50:17 GMT

Sorry, didn't cover that 🙂

It is even simpler:

... & replace(GetFieldSelections(fieldName), ', ', ' & ')

Need replace() to remove "natural separator (comma and space) with the desired "&"

Regards,

Michael

Fri, 20 Jul 2012 01:01:06 GMT

This one works too.. I got an e-mail from Kiran, Wanted to post the alternative.

Thanks Michael & Kiran.

='My Company Name' & chr(10) & if(getSelectedCount(fieldName)>0,concat(distinct fieldName, ' & '),'')