topic How to get sub reports in QlikView

How to get sub reports

Fri, 18 Dec 2009 12:07:26 GMT

Hi All ,

We are having one of the report requirement which is sub report of main report .

We are unable to get sub reports form main reports , by giving links to data inside our Pivot / Straight table .

Here we are attaching exact sub report structure , we need for our client.

Looking for best support as usual . 🙂

Main Report-1 :

Region	Customer Count	Total Spend
East	15	100010
West	5	50000
North	35	60000
South	24	75000

Sub Report -1

Region	Customer Name	Revenue	Total Visits
West	John	8000	2
West	Allan	12000	3
West	Mark	6000	1
West	Smith	14000	2
West	Peter	10000	3

Sub Report -2

Region	Customer Name	Bill Date	Bill No	Product_Code	Qty	Price	Total Spend	Visit
West	John	21/10/2008	A_101	PR_001	4	150	600	1
West	John	21/10/2008	A_101	PR_006	2	500	1000	1
West	John	18/12/2008	C_225	PR_011	3	600	1800	2
West	John	18/12/2008	C_225	PR_015	7	200	1400	2
West	John	18/12/2008	C_225	PR_021	8	400	3200	2

And we need to export these charts to excel if requried .

Bhushan N

How to get sub reports

Tue, 22 Dec 2009 14:05:25 GMT

Please help me in getting below requirement or any alternative way to get sub reports .

Its one of major requirement from our client .

Bhushan N

How to get sub reports

johnw — Wed, 23 Dec 2009 00:57:52 GMT

I guess I don't understand the question, or maybe you're making it harder than it needs to be. Build all three reports. When you select Region = West from your main report, you'll see sub report 1 for West. When you select Customer Name = John, you'll see sub report 2 for West and John. I don't see why you would need or want actual links when mere selections will produce the same result. If you don't even want to see the sub reports until the user selects a Region and then Customer Name, use a conditional show on the layout tab, getselectedcount("Region")=1 for sub report 1, and getselectedcount("Region")=1 and getselectedcount("Customer Name")=1 for sub report 2. You might consider getpossiblecount() instead so that if other selections have narrowed you down to one region and customer, you don't have to still explicitly selected them. But maybe I'm not understanding what you want.