topic How to use QUALIFY in QlikView

How to use QUALIFY

Mon, 08 Jul 2013 15:51:15 GMT

Help in how to use qualify.

MayilVahanan — Mon, 08 Jul 2013 15:55:09 GMT

For whole table:

Qualify *;

Load * from datasourcename;

UnQualify *;

For Field name in table:

Qualify B;

Load A,B from tableName;

Please refer the help for further details

Mon, 08 Jul 2013 16:03:37 GMT

I have used the Qualify like below as I don't have chance to use *. it's getting Field names must be Unique

Qualify *;

Load column1,column2,........ from datasourcename;

UnQualify *;

MayilVahanan — Mon, 08 Jul 2013 16:08:27 GMT

In datasourcename, is there any same column name??

Tue, 09 Jul 2013 08:12:10 GMT

Yes In one table it is name and in other table it is NAME. that's why it is getting field not found. please help

tresB — Tue, 09 Jul 2013 09:18:11 GMT

Hi,

it has been a long effort.

Lets try and check step by step:

Step1: Try to load the first table alone with Load * From.... . Is it going smooth? or getting that uniquness error?

if yes. It has nothing to do with qualify. your table is having multiple fields with same name; you have to identify that.

Once step1 is done will come up with step2.

Tue, 09 Jul 2013 11:31:25 GMT

QUALIFY will prefix field's name by table name like Table.Field

Beware of using it when you do some treatments on table.

It is better to use it only on the last table.

Don't forget to unqualify Fields you want to user as a key

Ex : Unqualify %K;

You may use a variable like

SET vUnqualify = Unqualify %K;

and then

$(vUnqualify);

So you have only one line to change

best regards

Chris