topic Re: QUALIFY in QlikView

QUALIFY

Thu, 11 Jun 2015 09:36:03 GMT

Hello,

Is there other method to replace QUALIFY ?

For exemple: I want to have two separate tables as following T1, T2,

but I can't creat a zone table or a simple table only with the table T1, it will be like figure[3].

Currently, I use QUALIFY to solve this problem, but evey time I have to enter as "T1.ID", " T1.Titre", ....

if I want to do the same thing for table T2, I have to do still a time the same thing with "T2.ID", .....

So I want to know if there are some betters methods.

thank you very much.

T1:

load * INLINE [

ID, Titre

1, Lion

2, Léon

3, Flower

4, Dark

]

;

T2:

NoConcatenate

load * INLINE [

ID, Titre

1, Lion

2, Léon

3, Flowers

4, Darck

5, Lion

]

;

figure[3]

Re: QUALIFY

IAMDV — Thu, 11 Jun 2015 09:39:15 GMT

I much prefer using Mapping Load for renaming the fields. Which contains existing names and new names.

Re: QUALIFY

avinashelite — Thu, 11 Jun 2015 09:39:36 GMT

Hi,

I did not understand want you wanted , Qualify is to make every column as unique and it s working as it meant for!!

can you please elaborate

Re: QUALIFY

Thu, 11 Jun 2015 10:09:30 GMT

Is there another way to that?

because with this method, evey time, we have to begine with the table name, for exemple T1.ID, I have write T1.

when I have many expressions, that's not convienient.

Re: QUALIFY

qlikview2015 — Thu, 11 Jun 2015 10:11:34 GMT

Hi !

Use

UNQUALIFY*;

at the end of the Script, or i did not understand the question !?

Berst regards

Mike Preuss

Re: QUALIFY

avinashelite — Thu, 11 Jun 2015 10:11:54 GMT

Ya, I got your point but we don't have other choice , else you need to do alias using the as statement and need to give the desired names, apart from this we don't have a alternative .

Re: QUALIFY

Thu, 11 Jun 2015 10:18:52 GMT

Ok, thank you anyway.

Re: QUALIFY

avinashelite — Thu, 11 Jun 2015 10:23:42 GMT

can you please close this thread !!

Re: QUALIFY

Peter_Cammaert — Thu, 11 Jun 2015 11:00:55 GMT

You don't have to qualify the first table. As far as I understand you, it can keep it's original column names.

The second table can be loaded as follows:

T2:

NoConcatenate

load ID as ID2, Titre as Titre2 INLINE [

ID, Titre

This may be simpler than specifying table prefixes for all fields, but you'll have to make sure that the correct associative links are still being made.

Peter

Re: QUALIFY

jonathandienst — Thu, 11 Jun 2015 11:29:32 GMT

i would concatenate the two tables, and add a source field to identify the source:

T1:

load *, 'T1' As Source

INLINE [

ID, Titre

1, Lion

2, Léon

3, Flower

4, Dark

]

;

Concatenate(T1)

load *, 'T2' As Source

INLINE [

ID, Titre

1, Lion

2, Léon

3, Flowers

4, Darck

5, Lion

]

;

Now use a set expression like {<Source = {'T1'}>} to select only from the T1 source.

Re: QUALIFY

Thu, 11 Jun 2015 12:30:21 GMT

Thank you, that's interesting. Buy every time we have to use the {<Source = {'T1'}>} in the expressions too.

In fait, I don't want to write every time the T1 for exemple, so I don't know if there is a way like the "State" to define also for this type.