Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

dadumas
Contributor

import a variables csv file into QlikSense

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.

Tags (1)
6 Replies
undergrinder
Valued Contributor II

Re: import  a variables csv file into QlikSense

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.

G.

reddys310
Honored Contributor II

Re: import a variables csv file into QlikSense

Hi David,

Yes its possible.

Check this out: could be of help to you.

Importing variables from excel

Thanks,

Sangram.

undergrinder
Valued Contributor II

Re: import  a variables csv file into QlikSense

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

dadumas
Contributor

Re: import a variables csv file into QlikSense

This is for QlikView, not QlikSense.

dadumas
Contributor

Re: import a variables csv file into QlikSense

Thanks - I will try this and let you know.

reddys310
Honored Contributor II

Re: import  a variables csv file into QlikSense

Apologies for that, thought it was a Qlikview post.