Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

andreyfcdk91
New Contributor III

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
Honored Contributor II

Re: Export to excel list of variables and their values

Highlighted
micheledenardi
Valued Contributor

Re: Export to excel list of variables and their values

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