topic Re: How to associate a Qualify Tables in QV Data Model? in QlikView

How to associate a Qualify Tables in QV Data Model?

Thu, 29 Sep 2016 18:59:00 GMT

Hi,

I have an application where I am using Qualify and Unqualify functions in script. Because of Qualify and Unqualify functions, one of the tables is not able to associate with Original table on some other field. Is there any way to associate it?

I tried changing the name of distinct table attribute on which I need to associate it with original table, but I am unable to run the script. How to tackle this?

Abhijit

Re: How to associate a Qualify Tables in QV Data Model?

sunny_talwar — Thu, 29 Sep 2016 19:06:22 GMT

Can you share the script you are using and the field you want to connect on from the Qualified table?

Re: How to associate a Qualify Tables in QV Data Model?

rupamjyotidas — Thu, 29 Sep 2016 19:06:42 GMT

You need to un-qualify the field you are associating

Foe Eg:

Qualify *;

UnQualify [Associating Field Name];

Re: How to associate a Qualify Tables in QV Data Model?

Thu, 29 Sep 2016 19:15:48 GMT

Thanks you for your reply. Here is my script and sample data.

On selection of dates in Scroll bar it should filter the data in table 2 as it is filtering the data in table 1.

Abhijit

Re: How to associate a Qualify Tables in QV Data Model?

Gysbert_Wassenaar — Fri, 30 Sep 2016 15:55:20 GMT

Try this:

QUALIFY *;

UNQUALIFY NOTICE, CPSC;

OriginalTable:

LOAD *, RecNo() AS RecID Resident JSR_Notice_With_Parts;

DistinctTable:

LOAD Distinct * Resident JSR_Notice_With_Parts;

UNQUALIFY *;

Inner Join (DistinctTable)

LOAD NOTICE ,

FirstSortedValue(DISTINCT CPSC, -Count) AS CPSC

GROUP BY NOTICE;

LOAD NOTICE, CPSC, Count(CPSC) AS Count

Resident JSR_Notice_With_Parts

Group By NOTICE, CPSC;

DROP Table JSR_Notice_With_Parts;

...etc...

Re: How to associate a Qualify Tables in QV Data Model?

Fri, 30 Sep 2016 18:48:19 GMT

Thank You Gysbert. I could associate it with the original model.

Abhijit

Re: How to associate a Qualify Tables in QV Data Model?

Fri, 30 Sep 2016 18:48:48 GMT

Thank You Rupam. It was helpful.

Re: How to associate a Qualify Tables in QV Data Model?

sudeepkm — Fri, 30 Sep 2016 18:56:41 GMT

Qualify *;

Unqualify <AssociativeFieldName>;

Load script; // Table Load script where you want to qualify field names other than <AssociativeFieldName>

Unqualify *; // need to put this at the end of load script otherwise the next table load script will take it as qualify.