topic Re: Variable in QlikView

Variable

Anil_Babu_Samineni — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have variable file like attachment.

I want to import these variables from one QVW to another QVW.

I want to show same as a.qvw variable to b.qvw variables with Values

- Anil

Re: Variable

MK_QSL — Tue, 21 Jun 2016 09:33:04 GMT

You can create an input box and add all variables here.

now using send to excel you can import them in an excel file.

now use below to use them in another qvw.

http://www.qlikfix.com/2011/09/21/storing-variables-outside-of-qlikview/

Re: Variable

bindu_apte — Tue, 21 Jun 2016 09:34:56 GMT

Hi Anil,

Hope these threads will help you.

Importing and exporting variables - The Qlik Fix! The Qlik Fix!

Transfer variable to another QVW File

Re: Variable

Frank_Hartmann — Tue, 21 Jun 2016 09:35:33 GMT

You can try with attached macro.

With first macro you can save all your variables to excel sheet and with the second you can import these Variables into another qvw.

hope that helps!

Re: Variable

Anil_Babu_Samineni — Tue, 21 Jun 2016 09:37:57 GMT

Manish,

Thanks for attempting.

I have Thousands of Variable, It takes time to add is there any other option to create a variable with that Variables??

Re: Variable

Frank_Hartmann — Tue, 21 Jun 2016 09:41:23 GMT

this might be helpful too!

How to store and recover variables

Re: Variable

MK_QSL — Tue, 21 Jun 2016 09:45:25 GMT

Great.. I haven't seen any application with THOUSANDS of variables...

Re: Variable

Anil_Babu_Samineni — Tue, 21 Jun 2016 09:47:21 GMT

Frank,

In that Variable it showing only Excel. But, I want to show all over here with Directly.

vImport1	='Imported variable #1'
vImport2	=Replace('$(vImport1)', '1', '2')
vImport3	=Left('$(vImport2)', Len('$(vImport2)') - 1) & (Right('$(vImport2)', 1) + 1)

Re: Variable

Anil_Babu_Samineni — Tue, 21 Jun 2016 10:17:11 GMT

Might be Previous Developer is Mad.

Anyway, Can i know After send to excel it showing like = as well.

Do we require to delete that field in Excel or what?

Re: Variable

MK_QSL — Tue, 21 Jun 2016 10:21:58 GMT

You can delete the 2nd field having '=' and use the link which is given...
This will allow you to import variables using excel file.

Re: Variable

Anil_Babu_Samineni — Tue, 21 Jun 2016 10:24:17 GMT

Manish,

Link is ok. But, When i follow the same way i am getting only one Variable that is first one..

Re: Variable

MK_QSL — Tue, 21 Jun 2016 10:25:50 GMT

You have to use something like below loop..

Temp_Variables:

LOAD Name,

Expression

FROM

YourFileName.xlsx

(ooxml, embedded labels, table is Variables);

For i=0 to NoOfRows('Temp_Variables')-1

Let vName = Peek('Name', i, 'Temp_Variables'); //Name of Variables

Let $(vName) = Peek('Expression', i, 'Temp_Variables'); //Definition of Variables

NEXT i;

Let i = null();

Let vName = null();

// Remove temp tables

Drop Table Temp_Variables;

Re: Variable

Anil_Babu_Samineni — Tue, 21 Jun 2016 10:31:58 GMT

When i load a.qvw file to b.qvw thru Binary it showing only dimensions.

I have one more question, If we are fetching the dimensions from another qvw why Groups(Drill, Cyclic) are not coming.

Can i know the reason??

Re: Variable

MK_QSL — Tue, 21 Jun 2016 10:35:33 GMT

Sorry bro. no idea