Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

age wise sum

i need to get the sum value of the stock so i need to create salb "90-120" "120-180"

Ihave two diffrent date range one is stock date other one is selected days.how to get the day wise summery

please give me the answer

3 Replies
jason_michaelid
Honored Contributor II

Re: age wise sum

Please provide examples of the data and the output you require.

Not applicable

Re: age wise sum

What i need is i need to create age analasys report for stock item wise and location wise

my problem is i can't create logic i already crete logic using excel but qlikview still am finding

i will attache you to excel file

think my date 2012/08/25 -480    i need find my stock location table how it define

ex -Age=0to90 /90-120 like wise

plase help on the i ll attache my file to you

this exsampale

selected Date(Mainstock Date)   /     Stock Qty

2012-08-25                                         56

location date                    Stock qty

25/08/201225
15/08/201210
03/07/201215
18/06/201230
10/06/20123
08/05/201220

0-3031-6061-90
35152

I need to create this report

Bold color items are Data please give me the help

jason_michaelid
Honored Contributor II

Re: age wise sum

Excel file?