Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
sagar_vij99
Creator
Creator

How to stop drill down in calculations

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

3 Replies
ogautier62
Specialist II
Specialist II

Hi,

could you attach a short example with expected result please :

I don't understand calculation of 2% :

2/10 = 0,2    ?

regards

rajivmeher
Creator
Creator

Hi sagar.vij99

Please try the following:

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

Regards

Rajiv.

balabhaskarqlik