Average Inventory Calculation

[vikas_nandanwar]

Hi,

Avg( Aggr( Sum(Qtyl), Date))

The above expression worked to some extent.

Now When i am drilling down to the final date, Its not giving me the correct answer.

I have my data as -

Date	Dept	WorkCenter	Sub Dept	Qty	Co. Code	Type
2-Jan-17	Mfg	A	PURE	10	ZZ	Gold
2-Jan-17	RM	B	KARAT	30	XX	Platinum
2-Jan-17	Mfg	C	PURE	30	YY	Silver
2-Jan-17	JW	A	SPRUE	20	ZZ	Platinum
2-Jan-17	Mfg	D	FIL	40	XX	Gold
2-Jan-17	RM	D	BAG	50	YY	Silver
3-Jan-17	Mfg	A	CHK	10	WW	Platinum
3-Jan-17	JW	B	FIL	20	VV	Gold
3-Jan-17	Mfg	C	FILWIP	20	WW	Gold
3-Jan-17	JW	B	CHK	10	VV	Silver
3-Jan-17	RM	C	FIL	30	XX	Platinum
3-Jan-17	RM	B	BAG	30	ZZ	Platinum
3-Jan-17	Mfg	A	CHK	20	YY	Silver
4-Jan-17	JW	B	FIL	50	VV	Gold
4-Jan-17	Mfg	C	FILWIP	10	WW	Gold
4-Jan-17	RM	B	BAG	20	VV	Silver
4-Jan-17	Mfg	C	FIL	40	XX	Platinum
4-Jan-17	JW	A	AAG	40	ZZ	Silver
4-Jan-17	Mfg	D	FIL	20	WW	Gold
4-Jan-17	RM	A	AAG	10	YY	Platinum

I need to check drill down on a single date say 2nd Jan = Total Inventory of Qty = 180

Note this is sample data and will contain data from 1st Jan to 31st Oct.

Thanks,

Vikas

[Anil_Babu_Samineni]

Show me the image of expression with full image

[vikas_nandanwar]

Here Total(Pure)=Qty (Field)

[Anil_Babu_Samineni]

Extremely Sorry, Question related Qliksense. But, You make sure to mention "In Place" should be Qliksense. So, It is  not existing function for sense. May be someone offer you

[vikas_nandanwar]

Didn't get you on that one

[Anil_Babu_Samineni]

If you give proper answer, Then we will get answer for you. From given data what are you going to get using simple Straight table? So, Then we can make for you

[vikas_nandanwar]

Hi,

I am giving you proper answer.
My final aim is-

1.     To get average inventory department wise whenever I am at multiple dates or at clubbed Month Level

2.     When I select a single date from filter, I should get total or Sum for that date

Vikas

[vikas_nandanwar]

Hi Anil,

I tried this one

And It worked

Thanks for the help.

I appreciate.