Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
dadumas
Creator II
Creator II

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.

6 Replies
undergrinder
Specialist II
Specialist II

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.

reddy-s
Master II
Master II

Hi David,

Yes its possible.

Check this out: could be of help to you.

Importing variables from excel

Thanks,

Sangram.

undergrinder
Specialist II
Specialist II

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

dadumas
Creator II
Creator II
Author

This is for QlikView, not QlikSense.

dadumas
Creator II
Creator II
Author

Thanks - I will try this and let you know.

reddy-s
Master II
Master II

Apologies for that, thought it was a Qlikview post.