topic Re: Expression in QlikView

Expression

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

Hi,

We have an application it re-direct to the different web page.Here i have used the logic [Report Name] &'<URL>'&[Wiki Link] but for some reports the there is no link (N/A).

I need to show the reports which doesn't have links as N/A.

Please find the attached QVW and spreadsheet for reference.I the below image i need to replace the marked as N/A.

Thanks..

Re: Expression

kaushiknsolanki — Mon, 12 Dec 2016 09:01:31 GMT

Hi,

Try this expression.

If(WildMatch(link,'N/A'),link,[Report]&'<URL>'&[link])

Regards,

Kaushik Solanki

Re: Expression

zhadrakas — Mon, 12 Dec 2016 09:05:03 GMT

try this Expression:

if([link]='N/A', 'N/A', [Report] &'<URL>'&[link])

Re: Expression

nareshthavidishetty — Mon, 12 Dec 2016 09:16:01 GMT

Thanks..Now i need to include two status as 'Pending' and 'N/A'.

Re: Expression

kaushiknsolanki — Mon, 12 Dec 2016 09:27:43 GMT

Use the same logic.

Regards,

Kaushik Solanki