topic Parent Child linking issue in QlikView

Parent Child linking issue

Wed, 04 Apr 2012 18:55:03 GMT

The attached excel file shows the two tables to work from (Sales Order Head and Sales Order Detail) and the two report output I am looking for. Basically, the Sales Order Head table holds orders for both Quotes and Regular orders. The Sales Order Detail holds the detail line information. A field in the Sales Order Detail file will have a reference to the Quote order number if that line relates to the quote.

Can seem to generate the linking (preferably in a "Fact Table") that gives me all that I want.

Thanks for any help.

Stephen

Re: Parent Child linking issue

adhudson — Thu, 05 Apr 2012 07:49:10 GMT

Hi,

Please find the below qvw file.

I think you ve got the solution

Regards

Andrew Hudson

Re: Parent Child linking issue

Thu, 05 Apr 2012 14:55:45 GMT

Thanks Andrew. I also finally solved it but in a different way (used right keep). I like your solution better. You took only 5 "queries/tables", I took 6.

Thanks,

Stephen

Re: Parent Child linking issue

adhudson — Mon, 09 Apr 2012 01:10:14 GMT

Hi,

It would be helpful if you could share your solution.

Just I need to see the right keep method of implementation.

It may help in sometime.

Thanks

Andrew Hudson

Re: Parent Child linking issue

Mon, 09 Apr 2012 15:28:47 GMT

See my solution attached.

Stephen

Re: Parent Child linking issue

Fri, 04 May 2012 21:22:16 GMT

With the solution Andrew provided you flip between showing a straight table for quote order detail or a second straight table that shows regular orders depending on which type of order is selected.

I would like see both reports. Meaning, if I select quote order 3001 I want to also see a report with the detail of the regular orders that relate to quote 3001 which is regular orders 6002 and 6003 and visa versa. If I select regular order 6003 then I want to also see a report that details quote order 3000 and 3001.

Can you help me with this?

Thanks,
Stephen

Parent Child linking issue

Fri, 04 May 2012 21:25:51 GMT

One more thing to the requirement above, I need the data in one fact table as security (section access) is implemented.

Thanks,
Stephen