topic Load data from text file in QlikView

Load data from text file

Tue, 18 May 2010 10:16:56 GMT

Please any body guide me, for example I have a text file name abc.txt in root directory or where else, which has two columns and four rows, data is given below:

Col1 Col2

A 4

B 5

C 6

D 7

====================================

and in application I have four input box name A, B, C and D, now I want when I press the macro button

then its read abc.txt file and put the values in input boxes according to A,B,C & D, is that possible ?

Load data from text file

Tue, 18 May 2010 10:22:09 GMT

Hi,

If i understood your question properly, below is the solution for your question.

Creat 4 variables and assign them to input box.

In Inputbox under "Constraints Tab" --> "Settings for Selected Varaiable" input this following expression.

sum

And to check the input box behaviuor , change the value at back end and press reload button to get the new values in input box.

Check the attached application

Hope this will help you.

- Peterson

(if(Col1 = 'A',Col2))