topic How to: Pass results of query 1 into query 2 in QlikView

How to: Pass results of query 1 into query 2

newqlik2017 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

Is it possible to pass the aggregated metric AMOUNT value from query 1 into query 2 that has additional fields but not the AMOUNT ? When a user makes a filter selection, the AMOUNT column should be reflected in the detail for each columns from query 2.

Table 1 has the aggregated Amount at Dim1/Dim2/Account level

Table 2 has the other fields but no Amount.

Filters to be used are: Dim1, Dim2, Account, State, County, City, Zip

Please see data set below for example. I also attached a qvw for reference.

Dim1	Dim2	Account	Amount
Agriculture	AA	AA111	1000
Education	AA	AA112	2500
Retail	AA	AA113	4500
Agriculture	BB	BB211	2000
Education	BB	BB212	3500
Retail	BB	BB213	5000

Dim1	Dim2	Account	State	County	City	Zip
Agriculture	AA	AA111	NY	AC1	Manhattan	A101
Agriculture	AA	AA111	PA	AC2	Pittsburgh	A201
Education	AA	AA112	CA	EC1	Los Angeles	A301
Retail	AA	AA113	NY	RC1	Manhattan	A401
Retail	AA	AA113	FL	RC1	Miami	A501
Retail	AA	AA113	FL	RC2	Orlando	A502
Retail	AA	AA113	NJ	RC1	Edison	A601
Agriculture	BB	BB211	CA	AC1	Los Angeles	B101
Education	BB	BB212	NY	EC1	Brooklyn	B201
Education	BB	BB212	CA	EC1	Hollywood	B301
Education	BB	BB212	CA	EC2	San Fransicso	B302
Retail	BB	BB213	PA	RC1	Pittsburgh	B401
Retail	BB	BB213	PA	RC1	Philadelphia	B402
Retail	BB	BB213	PA	RC2	Erie	B403
Retail	BB	BB213	PA	RC3	Harrisburgh	B404

Re: How to: Pass results of query 1 into query 2

Lisa_P — Tue, 24 Apr 2018 00:51:10 GMT

Hi Subash,

I'm not exactly sure what you are looking for here.

I've just added in a straight table and a pivot table to your list boxes and table boxes.

Hope it helps.

Re: How to: Pass results of query 1 into query 2

newqlik2017 — Tue, 24 Apr 2018 14:19:11 GMT

Hi Lisa,

Thank you for your response.

In your qvw, for example, if you select Agriculture from Dim1, the total amount is 1000. Now, if you look for the same across state or county or zip, the total amount is always 1000; however, I'm looking for a breakdown of that 1000 by state, county, zip or whatever filter is selected.

Hope this makes sense.

Re: How to: Pass results of query 1 into query 2

qlikwiz123 — Tue, 24 Apr 2018 16:06:28 GMT

Hi,

I am not sure if I understood the question. But if you are looking at Dim1 - Agriculture and Dim2 - AA, there is NY and PA in states and Manhattan and Pittsburgh in the City.

Since the data doesn't show the Agriculture-AA amount split between these two States or Cities, it is not possible to divide that 1000 among these.

If that is not something you are looking for, please let us know the requirement with some more information.