Drill in TOTAL function

[rkspareek1992]

Hi,

I am using TOTAL function in dril down chart.

When I am showing data in front then its totaling with respect to fields, but when I am drilling chart then its showing same total.

At the result of drill I wants separate values, but when I am using TOTAL function its only showing total values.

kindly Suggest

Below is the example:

Here its calculating A/total (B)

Expression:

sum({<Year={'$(vMaxYear)'},MATKL={'CM*'},[Work Center Sub Group]={'Rotary Furnace'},[Segment Final]={'Lead'}>}Quantity_MSEG_FlagConsumption2)/

Sum(total<[Plant Name]>{<Year={'$(vMaxYear)'},BWART1={'101_102'},[Work Center Sub Group]={'Rotary Furnace'},[Segment Final]={'Lead'},[Material Name]>}Quantity_MSEG)

Material Name	A/B
	31.17
Used Oil	31.17

But when I am using used oil then its also showing same value (31.17), but I wants to select respected values.

[sunny_talwar]

Are you doing Consumable/Production or Production/Consumable? You mentioned 6579/25570 after selection, but 6579 is production? Why is it in the numerator? Also, this seems like a Qlik Sense question.... can you move the discussion to Qlik Sense so that right people can take a look at this?

[rkspareek1992]

Sorry,

this is consumable/Production...

This would be 25570/6579.

[sunny_talwar]

Try removing [Material Name] from your denominator expression

Sum({<Year={'$(vMaxYear)'},MATKL={'CM*'},[Work Center Sub Group]={'Rotary Furnace'},[Segment Final]={'Lead'}>}Quantity_MSEG_FlagConsumption2)/

Sum(total<[Plant Name]>{<Year={'$(vMaxYear)'},BWART1={'101_102'},[Work Center Sub Group]={'Rotary Furnace'},[Segment Final]={'Lead'},[Material Name]>}Quantity_MSEG)

[rkspareek1992]

I cannot remove material name, because data is as like that:

Material Name	Con	Prod	Con/Prod
	797062.00	25570.42	31.17
1	0.00	25570.42	0.00
2	0.00	25570.42	0.00
3	0.00	25570.42	0.00
4	0.00	25570.42	0.00
5	0.00	25570.42	0.00
Used Oil	797062.00	25570.42	31.17

There is no production with respect to Used Oil.

[sunny_talwar]

Where does 6579 comes from?

[rkspareek1992]

This is data format (in qlikview) not exact values..

[sunny_talwar]

I think somebody else might have a better understanding of your issue. I don't think I am able to understand the issue well enough to help.

Best,

Sunny