topic Re: Drill down issue. in QlikView

Drill down issue.

ganeshreddy — Sun, 30 Aug 2015 07:05:24 GMT

Hi All,

Here Organization drill down group is not working for Total equipment metric(Last one in table) in the first table. can anyone help me out here.

Note: total equipment count in both tables should match.

Best Regards,

Ganesh

Re: Drill down issue.

ganeshreddy — Sun, 30 Aug 2015 09:09:05 GMT

Hi jagan‌ sunindia‌ kavita25‌ swuehl‌ gwassenaar‌ , can you guys help me on this issue, do I need to make any data model changes to achieve the requirement or expression changes will be fine.

Best regards,

Ganesh.

Re: Drill down issue.

Anonymous — Sun, 30 Aug 2015 12:09:03 GMT

Ganesh,

As I can see, they match already.

Except in the situation if you make selections in the dimension of the second table. And, it is obviously done deliberately - the expression in the first table has set analysis that ignores the selections made in the second table drill-down dimension.

Regards,

Michael

Re: Drill down issue.

Anonymous — Sun, 30 Aug 2015 12:28:58 GMT

Seems both are matching .

Re: Drill down issue.

ganeshreddy — Sun, 30 Aug 2015 12:32:05 GMT

Hi Michael,

Thanks for the replay.They are matching, if there is no selections in first table. if you click on the first region value of first table which got total value as 122, it is giving 144 as total value(which is wrong accrding tom drill down properties). Please provide me solution on this.

Best Regards,

Ganesh.

Re: Drill down issue.

ganeshreddy — Sun, 30 Aug 2015 12:34:31 GMT

Hi Rgv,

Thanks for the reply. Yes they are matching initially, but not after making first selection in first table. Plese provide me a solution for this.

Best Regards,

Ganesh.

Re: Drill down issue.

Anonymous — Sun, 30 Aug 2015 13:22:19 GMT

ganeshreddy

It seems to be working fine .Count of Equipment Id is matching in both table even after selections in drill down .

2nd Selection District

3rd Selection

4th Slecion

This is what i understood.

If this is not your requirement let me know your desired result

Re: Drill down issue.

ganeshreddy — Sun, 30 Aug 2015 14:05:12 GMT

Hi Rgv,

You can see the difference in your screen shoots itself, if you click on 'Smya' (contains 122 as total) in first screen, from the second selection total is showing 142 it should be 122 according to drill down property I am right. This is what the problem i am facing. I think I have explained my problem right if not please ask me

Best regards,

Ganesh..

Re: Drill down issue.

Anonymous — Sun, 30 Aug 2015 15:05:44 GMT

Why don't you use

Count(distinct EquipmentId)

in the first table? The result will always match in that case.

Maybe you have a good reason for a more complex expression which I don't see (?)

Re: Drill down issue.

ganeshreddy — Sun, 30 Aug 2015 16:36:29 GMT

Hi Michael,

If i use count(distinct EqipmentId), field values for region are coming as wrong values. As you can see by replacing it, values are 142 and 84 != 206 but it should be x+x = 206.

Thanks,

Best Regards,

Ganesh.

Re: Drill down issue.

ganeshreddy — Sun, 30 Aug 2015 17:02:32 GMT

I suspect that profit center table is not related to out calculation, if so please give me an advice to do data model changes.

Thank you,

Ganesh.

Re: Drill down issue.

ganeshreddy — Wed, 02 Sep 2015 07:28:13 GMT

Hi All,

I got the answer for this issue, thanks to everyone who involved in this discussion, application gone for QA. I did data model changes like inner joined profit center id with work order table, aggregated WOSummary calculations with Equipment ID and Equipment Model name insted only Equipment model name . In this case Total/field values are coming right and drill down is working fine as well.

Best Regards,

Ganesh Reddy.