topic Re: Display variable in table in QlikView

Display variable in table

jagannalla — Mon, 20 Jun 2011 06:33:24 GMT

Hi,

I have a variable in my qvw file. Now i want to display this variable in table.

- If is possible to store this variable in text file along with data.

Re: Display variable in table

Miguel_Angel_Baeyens — Mon, 20 Jun 2011 06:37:38 GMT

Hi,

Anytime you want to store anything in a file, you need to previously load it, unless you want to use some unnecessary (in my point of view) macro code.

VariableTable:
LOAD $(vVariable) AS Variable
AUTOGENERATE 1;
STORE VariableTable INTO File.txt (txt);

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Display variable in table

kaushiknsolanki — Mon, 20 Jun 2011 06:39:40 GMT

Hi,

You can display variable in Straight Table. Just place "=Varibale_Name" in Expression if it contains value. If it is an expression then use "=$(Variable_Name).

For second Question - Yes you can store varibales in text file and then use them in Qlikview.

Regards,

Kaushik Solanki

Display variable in table

jagannalla — Mon, 20 Jun 2011 06:52:55 GMT

Miguel,

what you said correct but the think is when i'm using this text file in another qvw file using include statement (i.e., $(Include=d:\examples\file.txt);). Shows the error message while loading qvw file.

Re: Display variable in table

kaushiknsolanki — Mon, 20 Jun 2011 07:01:57 GMT

Hi,

Its because you have not declared the variable properly in text file.

Make sure your text file have variable declaration like below.

Set vVariable1 = 'ABC';

Set vVariable2 = 'PQR';

............... And so on,

Hope this will help you.

Regards,

Kaushik Solanki

Display variable in table

jagannalla — Mon, 20 Jun 2011 07:30:37 GMT

Kaushik,

I created the vVariable globally and now i'm using this variable in edit script. The think is i want to store this variable in text file and i want to use the data of particular variable.

As per miguel give code its creating a variable along with data in the text file. How to set variable property in text file as per code given my miguel.

Re: Display variable in table

kaushiknsolanki — Mon, 20 Jun 2011 07:40:39 GMT

Hi,

Can you please explain what are you trying to achieve, this will help us to understand your problem in detail.

Regards,

Kaushik Solanki

Re: Display variable in table

Miguel_Angel_Baeyens — Mon, 20 Jun 2011 07:45:33 GMT

Hi,

Are you using "File.txt" (the file where you previously stored the table with the variable) as the include file? In that case, you will need to LOAD the file instead of use it in the include, since it's not properly formatted to be used as a piece of script code.

In other words, you cannot save a txt file with a variable as a field (as in my example above) and then use it in the include variable. The include variable inserts the text in the file specified in the script, and so this text must be a valid script code.

Here's my guess on what you want to get

// Load variable saved in previous STORE statement or in a different document
Variable:
LOAD Variable
FROM
C:\File.txt
(txt, utf8, embedded labels, delimiter is '\t', msq);
LET vDestinationVariable = FieldValue('Variable', 1);
DROP TABLE Variable; // Cleanup

Now, in the second file, vDestinationVariable has the same value it has in the file you have stored it.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: Display variable in table

jagannalla — Mon, 20 Jun 2011 08:09:13 GMT

Thanks a lot miguel I need some more help from you.

- If the variable contains the data in string format i mean i.e., vVariable=A or vVariable=A,B,C,D

It showing an error.

What i'm trying to achive is i had taken a list box and based on my selections i'm storing particular selections into variable.

I'll attach my file for your reference to understand what i'm doing.

Re: Display variable in table

kaushiknsolanki — Mon, 20 Jun 2011 08:23:30 GMT

Hi,

All you have to do is place $(Variable) in single quote ie.

load

'$(Variable)' as Variable

............

Go through the attahcment.

Hope this will help you

Regards,

Kaushik Solanki

Re: Display variable in table

Miguel_Angel_Baeyens — Mon, 20 Jun 2011 08:38:19 GMT

Hi,

Change your action in the Click button to the following so each of the possible text values are quoted so they can be used later:

=chr(39) & GetFieldSelections(Group,chr(39) & chr(44) & chr(39)) & chr(39)

That will store 'A','B', etc in the variable

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: Display variable in table

jagannalla — Mon, 20 Jun 2011 09:36:57 GMT

kaushik / Miguel,

Thanks a lot both of you. If there is any possibility to reload "Secondary qvw file " when we are navigating from "primary qvw file" to " Secondary qvw file ". I know how to open another qvw file on button action but i don't know how to reload second qvw file while we are navigating.

- And one more thing is when i'm keeping the positions of action for a button to reload and open another qvw file. It is not working. The positions can be seen in below image:

- If the positions are like below image it is navigating to another file..

Re: Display variable in table

Miguel_Angel_Baeyens — Mon, 20 Jun 2011 10:00:36 GMT

Hi,

Yes, the order of the actions is important. In your macro, you are reloading, so the application stops its macros and reloads. Once it has reloaded, it doesn't continue executing macros, because it's a different action (take a look at the Settings menu, Document Properties, Triggers, Document Event Triggers, OnOpen or OnPostReload).

You cannot reload one document from another, but following with the above, you can set a trigger so when the second document is opened (OnOpen), it reloads.

I'm assuming you are not working with server. If you are, some of these actions may not work when you open the document from a client.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: Display variable in table

jagannalla — Mon, 20 Jun 2011 10:15:25 GMT

Miguel,

Yes you are right i'm not working on server. I had tried previously to reload the document with triggers but it is not working .When i close the qvw file and open manually it is working. So i felt that there is another method to reload the document on navigating. But your breif description had given me information how and where it will work.

- Miguel, right now i'm storing a single variable in one txt file. But, if there are multiple variables how can i store into same txt file and use those variables in another qvw file.

Re: Display variable in table

Miguel_Angel_Baeyens — Mon, 20 Jun 2011 10:29:04 GMT

Hi,

Regarding your question about variables, and according to the code above, I'd store each value in a different field, so you can later load that file and assign each field to the corresponding variable in the second document, and not using the include variable for this case.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: Display variable in table

jagannalla — Mon, 20 Jun 2011 11:11:38 GMT

Hi,

I tried with different variables and i can able to store in one txt file. But think is when i'm loading txt file into second qvw file it is loading all variables as one field.

The code is like following in different files:

// First file

VariableTable:

LOAD '$(varName)' AS Variable,

$(vAnotherName) as Variable1 // vAnotherName =1

AUTOGENERATE 1;

STORE VariableTable INTO File.txt (txt);

// Second file

LOAD [Variable,Variable1]

FROM

D:\Examples\File.txt

(txt, utf8, embedded labels, delimiter is '\t', msq);

LET vDestinationVariable = FieldValue('Variable', 1);

// LET vDestinationVariable1 = FieldValue('Variable1', 1);

Re: Display variable in table

Miguel_Angel_Baeyens — Mon, 20 Jun 2011 11:37:23 GMT

Hi,

Do instead

LOAD Variable,

Variable1

...

Brackets are used to specify a field name when it contains blanks, special characters or something.

Hope that helps

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Display variable in table

jagannalla — Mon, 20 Jun 2011 11:41:54 GMT

Ya..I got the solution. We need to select Delimiter as Comma while loading the txt file.