Storing IP address in qlikview link and using that in a chart

[deepakqlikview_123]

Hi All,

I am using below link in qlikview expression

If(Dimensionality() = 0 , '', 'Click here to Add Notes<url>http://&''&$(vIP)/Qlik/aspAddCustomerInvoice.aspx?CustomerNo='&CustNo &'&'&'InvoiceNo='&InvoiceRefNo &'&'&'AddedBy='&' '&(Vuser)&'&CompanyId='&(COMPANYID1))

I am storing IP address in vIP='172.23.11.22'

But I am not able to use the variable in above link can you please suggest how shall i use the variable for same.

Thanks

[marcus_sommer]

Are you sure that your url is valid - how does they look like if you hoover over them (bottom left of the screen within the browser)?

- Marcus

[mayankraoka]

HI Deepak,

Can you give it a try without $ sign like this:

If(Dimensionality() = 0 , '', 'Click here to Add Notes<url>http://&''&(vIP)/Qlik/aspAddCustomerInvoice.aspx?CustomerNo='&CustNo &'&'&'InvoiceNo='&InvoiceRefNo &'&'&'AddedBy='&' '&(Vuser)&'&CompanyId='&(COMPANYID1))

Regards,

Mayank

[deepakqlikview_123]

Done man, I got the solution

=If(Dimensionality() = 0 , '', 'Click here to Add Notes<url>http://'&$(vIP)&'/Qlik/aspAddCustomerInvoice.aspx?CustomerNo='&CustNo &'&'&'InvoiceNo='&InvoiceRefNo &'&'&'AddedBy='&' '&(Vuser)&'&CompanyId='&(COMPANYID1))

How are u

[mayankraoka]

Great..you got the solution.

I am good buddy.