topic Re: Qualify statement doubts in QlikView

Qualify statement doubts

Mon, 15 Dec 2014 10:10:59 GMT

Hi All,

I have a basic doubt in qualify statement. As per the contents section in QV this is the example given for qualify

qualify *;

unqualify TransID;

select * from tab1;

select * from tab2;

select * from tab3;

Only TransID will be used for associations between the tables tab1, tab2 and tab3.

As per my interpretation of the Qualify statement TranID will be the only field not be qualified, Am I right ? Can any one explain me the in detail with a small example for qualify.

Thanks in Advance,

Sai.

Re: Qualify statement doubts

Mon, 15 Dec 2014 10:12:24 GMT

only trans id is unqualified statement

rest of the fields are qualifed

Re: Qualify statement doubts

Mon, 15 Dec 2014 10:16:25 GMT

Thanks for the quick reply.

Re: Qualify statement doubts

Mon, 15 Dec 2014 10:17:15 GMT

welcome

Re: Qualify statement doubts

its_anandrjs — Mon, 15 Dec 2014 10:18:23 GMT

Hi,

Here in all table load TransID is only unqualify field

Ex:-

Qualify *;

Unqualify TransID;

Table1:

select * from tab1;

select * from tab2;

select * from tab3;

After all this load assume you get fields like

TransID,Table1.field1,Table1.field2,Table1.field3........

Regards

Anand