topic Re: import a variables csv file into QlikSense in App Development

import a variables csv file into QlikSense

dadumas — Wed, 03 Feb 2016 15:43:13 GMT

I use an external excel file for all my QlikView variable definitions. I use a for...next loop to load them in, after my binary loads This works great.

I do not see a way to do this in QlikSense. If it is possible, I assume this would get loaded into QlikSense Master items?

Has anyone done this? I would hate to have to type them in one by one as Master Items.

Re: import a variables csv file into QlikSense

undergrinder — Thu, 04 Feb 2016 08:36:46 GMT

Hi David,

If you think a variable as let/set = 123; thing that you can use the include statement, that you can see in the

Script Syntax and Chart Functions Guide or check Can we import script file into Qliksense?‌ thread.

If you think variable as a master item, you can't achive this from script.

Re: import a variables csv file into QlikSense

reddy-s — Thu, 04 Feb 2016 09:39:19 GMT

Hi David,

Yes its possible.

Check this out: could be of help to you.

Importing variables from excel

Thanks,

Sangram.

Re: import a variables csv file into QlikSense

undergrinder — Thu, 04 Feb 2016 09:55:49 GMT

Is this function available to Qlik Sense too? I thought it works only in QlikView.

Re: import a variables csv file into QlikSense

dadumas — Thu, 04 Feb 2016 13:51:47 GMT

This is for QlikView, not QlikSense.

Re: import a variables csv file into QlikSense

dadumas — Thu, 04 Feb 2016 13:52:45 GMT

Thanks - I will try this and let you know.

Re: import a variables csv file into QlikSense

reddy-s — Fri, 05 Feb 2016 10:11:22 GMT

Apologies for that, thought it was a Qlikview post.