Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Export to excel list of variables and their values

Colleagues, good day!

Could anyone advice, is there in QV some standard tool to export data of all variables and their values (i mean definitions)?

For example, i have one variable vSales, value = sum(Sales)

I need to export this data in this format:

Variable  Value

vSales    sum(Sales)

Thanks for advice.

kind regards, Andrey

2 Replies
prieper
Master II
Master II

micheledenardi
Specialist II
Specialist II

I have found this discussion: https://community.qlik.com/docs/DOC-18581

The reasoning is little bit different from yours but i think is the best solution.

Basically you have to define your variable into an xls file and the load them into your QV doc by using this script:

Capture.PNG

See also these video: Qlikview Export Variables from Qlikview by RFB 102 - YouTube

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.