Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get sub reports

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 :

RegionCustomer CountTotal Spend
East15100010
West550000
North3560000
South2475000


Sub Report -1

RegionCustomer NameRevenueTotal Visits
WestJohn80002
WestAllan120003
WestMark60001
WestSmith140002
WestPeter100003


Sub Report -2

RegionCustomer NameBill DateBill NoProduct_CodeQtyPriceTotal SpendVisit
WestJohn21/10/2008A_101PR_00141506001
WestJohn21/10/2008A_101PR_006250010001
WestJohn18/12/2008C_225PR_011360018002
WestJohn18/12/2008C_225PR_015720014002
WestJohn18/12/2008C_225PR_021840032002


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

Bhushan N

2 Replies
Not applicable
Author

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

johnw
Champion III
Champion III

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.