topic Re: Using Environment Variables in Qlik Sense - Dynamic Path to data in Connectivity & Data Prep

Using Environment Variables in Qlik Sense - Dynamic Path to data

Anonymous — Mon, 16 Feb 2015 06:14:06 GMT

Hello All,

Can we define variables and use them for dynamically deciding the path for data extract in Qlik Sense Desktop?

The following works on QlikView:

https://crm.zoho.com/crm/private/xml/$(pTable)/getRecords?authtoken=$(vAuth)&newFormat=1&scope=crmapi&fromIndex=$(pStart)&toIndex=$(pEnd)&lastModifiedTime=$(pDate)] (XmlSimple, Table is [response/result/$(pTable)/row/FL]);

I want to be able to put table names and other variables in the Data path.

Thanks,

Saurabh Pandit

Re: Using Environment Variables in Qlik Sense - Dynamic Path to data

jagan — Tue, 17 Feb 2015 07:14:35 GMT

Hi Saurabh,

May be Michael Tarallo helps you on this.

Regards,

Jagan.

Re: Using Environment Variables in Qlik Sense - Dynamic Path to data

Michael_Tarallo — Tue, 17 Feb 2015 12:46:26 GMT

Hi Saurabh - (Jagan thanks for bringing this to our attention)

This is possible if you disable Standard mode - documentation here:

It looks like you were attempting to use the Web File data connection and then populate the URL field with the URL you put in the original post. This WILL NOT WORK - with the default data connection mode. If you disable standard mode, YOU CAN USE the variables - but you need to put the connection information in the script - JUST LIKE YOU WOULD when using QlikView.

As in:

LOAD @1,

     @2,

     @3,

     @4,

     @5,

     @6

FROM

[http://www.mockaroo.com/1cd849d0/download?count=1000&key=0a1dac60]

(txt, codepage is 1252, no labels, delimiter is ',', msq);

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

let us know how you do

Regards,

Mike Tarallo

Qlik

Re: Using Environment Variables in Qlik Sense - Dynamic Path to data

Masaki_Hamano — Tue, 17 Feb 2015 12:50:00 GMT

Hi Saurabh,

You can achieve it by disabling standard mode (=enabling legacy mode). Please refer to the following URL:

https://help.qlik.com/sense/en-us/online/Subsystems/WorkingWith/Content/LoadData/DisableStandardMode.htm

Masaki

Re: Using Environment Variables in Qlik Sense - Dynamic Path to data

Anonymous — Fri, 20 Feb 2015 02:06:23 GMT

Thanks Michael,

Thanks for your help.Thanks Jagan for pointing the question to you.

I am aware of the Server side Legacy mode settings. I wanted to try and implement it in Desktop mode.

What I currently do is create qvds in QlikView and then import into Sense.
I wanted to reload data directly in Qlik Sense app which I should be able to do now by using the server only.

There seems no option to do it via legacy mode in Desktop.

Though it is not much of a problem as App development can seamlessly be done on the server.

Cheers,

Saurabh Pandit

Re: Using Environment Variables in Qlik Sense - Dynamic Path to data

Anonymous — Fri, 20 Feb 2015 02:09:46 GMT

Just a note worth mentioning in relation to someone facing similar issues.

Sometimes the client may have different groups accessing the same app and then need to refresh from separate data sources. We would typically use variables in similar situation.
You can explore applying the new rule based security to data connections via the server to solve the issue.

Hope that helps.

Cheers,

Saurabh Pandit

Re: Using Environment Variables in Qlik Sense - Dynamic Path to data

arsal_90 — Sat, 03 Oct 2015 14:08:22 GMT

Hi Saurab,

Can you share me the demo app that showing how to fetch data from ZOHO CRM.

I just need the code i mean how to Fetch table. Example LEAD Table.

Thanks & Regards,

Arsal

Re: Using Environment Variables in Qlik Sense - Dynamic Path to data

Mon, 05 Oct 2015 20:35:29 GMT

Hi Surabh,

I am facing data fetching issue while fetching data from Zoho CRM. Can you please share the code for fetching data from Leads table.

Thanks & Regards,

Arsal

Re: Using Environment Variables in Qlik Sense - Dynamic Path to data

Anonymous — Tue, 10 May 2016 01:39:55 GMT

I just posted a worked example pulling Potentials data using a custom view. You can adapt this for leads. ZOHO API with Qlik REST Connector and table transpose

Re: Using Environment Variables in Qlik Sense - Dynamic Path to data

Anonymous — Tue, 10 May 2016 01:42:53 GMT

Better to pass the variables to the REST Connector like this.

WITH CONNECTION (

QUERY "param1" "$(param1)",

QUERY "param2" "$(param2)"

);

There's a full worked example here: ZOHO API with Qlik REST Connector and table transpose