topic Re: How to stop drill down in calculations in QlikView

How to stop drill down in calculations

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

hi,

i am doing some calculations where i have 2 tables.

table 1 have columns product, process, subprocess and volume.

table 2 have columns product, process, subprocess and query count

i want to calculate percentage of query count in respect to volume. But i want to take denominator(volume) till process level only.

this means if i select any product then product then it should take numbers from query count for that particular process but volume number should be product wise not process wise. like sum of volume for product A is 10 and it has process x and y with volume 4 and 6. in table 2 query count for x and y is 2 and 3. so the % calculation should be 2% and 3%. for this i have expression sum(query count)/sum(total volume).

Now when go another level down and click any process, the calulation changes as it takes volume for that particular process only as denominator. i want to restrict it to product level.

How can i do it..?

Regards

Sagar

Re: How to stop drill down in calculations

ogautier62 — Fri, 31 Aug 2018 10:03:25 GMT

Hi,

could you attach a short example with expected result please :

I don't understand calculation of 2% :

2/10 = 0,2 ?

regards

Re: How to stop drill down in calculations

rajivmeher — Fri, 31 Aug 2018 22:16:59 GMT

Hi sagar.vij99‌

Please try the following:

(SUM(TOTAL <process>[query count]) / SUM(TOTAL <product>volume))

Regards

Rajiv.

Re: How to stop drill down in calculations

BalaBhaskar_Qlik — Sun, 02 Sep 2018 15:02:48 GMT

May be refer this:

Changing Dimension limits on drill down group