topic Re: URL In Straight Table in QlikView

URL In Straight Table

mparker123 — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I am trying to put a URL link into a straight table. When I put in the expression the field is blank and not showing any values. If someone can take a look my expression? I would appreciate it.

=if( epic_cf_pmo_project_type='Epic' and project_name<>'PMO Test' and project_name<>'PMO IMS Pipeline' and epic_status<>'Not Required' and epic_status<>'Done',epic_key, [epic_key] & '<URL> http://google.com & epic_key)

Re: URL In Straight Table

marcus_malinow — Wed, 30 Aug 2017 13:44:19 GMT

Try this:

=if(ONLY(epic_cf_pmo_project_type)='Epic' and ONLY(project_name)<>'PMO Test' and ONLY(project_name)<>'PMO IMS Pipeline' and ONLY(epic_status)<>'Not Required' and ONLY(epic_status)<>'Done',epic_key, [epic_key] & '<URL>http://google.com/‌' & epic_key)

Re: URL In Straight Table

Anil_Babu_Samineni — Wed, 30 Aug 2017 13:46:33 GMT

Are you just doing concat the string to field?

Re: URL In Straight Table

marcus_malinow — Wed, 30 Aug 2017 13:48:59 GMT

CORRECTION -

=if(ONLY(epic_cf_pmo_project_type)='Epic' and ONLY(project_name)<>'PMO Test' and ONLY(project_name)<>'PMO IMS Pipeline' and ONLY(epic_status)<>'Not Required' and ONLY(epic_status)<>'Done',ONLY(epic_key), ONLY([epic_key]) & '<URL>http://google.com/' & ONLY(epic_key))

Re: URL In Straight Table

mparker123 — Wed, 30 Aug 2017 15:19:35 GMT

when i use this it works but it populates the straight table with values that should be filtered out and are filtered out with my other expressions.

Re: URL In Straight Table

marcus_malinow — Wed, 30 Aug 2017 15:25:12 GMT

Great, as it works, please mark my answer as correct

You'll need to add some additional criteria to base the display of this on your other expressions.