Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

how obtain daily values from event's file

Sorry!

I'm novice and do not able to solve one task.

There is table with events of warehouse income and outcome events. There is also coloumn with warehose content for this date.

But i want to analyse on daily basis

Script for reading

MAX_Output:

LOAD Склад,          //WH

     Код,                  //Code

     Наименование, //Name

     Дата,                //Date

     [Приход РУБ],  //income price

     [Расход РУБ],  //outcome price

     [Запас РУБ]     //WH content

FROM

(ooxml, embedded labels, table is history);

LOAD

date(today()-recno(),'DD.MM.YY') as TransDate

AUTOGENERATE today() - MakeDate(2012, 1, 1);

Table (cutted)

СкладКодНаименованиеДатаПриход РУБРасход РУБЗапас РУБ
600121886-4081Прессформа01.01.201255271,74
600013424901802Клемма ф1001.01.20120
600013424901802Клемма ф1001.06.20122544525445
600013424901802Клемма ф1008.06.2012254450
600013424901802Клемма ф1008.04.20132544525445
600013424901805Клемма ф4001.01.20120
600013424901805Клемма ф4001.06.20122929229292
600013424901805Клемма ф4008.06.2012292920
60012551416Втулка Отливка01.01.20121276,7836
60001551417Подшипник Отливка01.01.2012479,00727
60001551883Зажим22.03.20121160,23510442,115
60001551883Зажим13.04.20121740,35258701,7625
60001551883Зажим07.09.20123480,7055221,0575
60001551883Зажим17.09.20123480,7051740,3525
60012552140Рычаг01.01.20121950,78
60012552140Рычаг07.09.2012650,261300,52
60001552237Шестерня отливка01.01.2012588,364
60001552464Кронштейн01.01.2012299,78
60001552464Кронштейн15.05.2012299,780
60001552464Кронштейн16.10.2012899,34899,34
60001552464Кронштейн25.10.2012899,340
60001552532Держатель конт. отливка01.01.201210624,959
60001552532Держатель конт. отливка19.01.20125902,7554722,204
60001552532Держатель конт. отливка07.05.20132361,1022361,102
60001552606Кронштейн отливка01.01.20122790,575
60001552608Держатель отливка01.01.20127325,5
60001552608Держатель отливка19.01.20127325,50
60001552608Держатель отливка16.10.201238223822
60001552608Держатель отливка20.11.201238220
60001552608Держатель отливка20.05.201338223822
60014551883Зажим22.03.20121160,23510442,115
60014551883Зажим13.04.20121740,35258701,7625
60014551883Зажим07.09.20123480,7055221,0575
60014551883Зажим17.09.20123480,7051740,3525

Want to obtain something like this one:

Image 3.jpg

4 Replies
Not applicable

Re: how obtain daily values from event's file

Hi Andrey, If you want analyze only on daily basis, You dont need a calender table:

Just Transform data Income & Out come WH Contet convert into numbers.

Please find the attached qvw for reference.

luis_pimentel
Contributor III

Re: how obtain daily values from event's file

If I am understanding correctly, you are already analyzing on daily basis, but instead of a bar chart you could use a line chart.

Not applicable

Re: how obtain daily values from event's file

Hi Luis, I am using line chart.

Not applicable

Re: how obtain daily values from event's file

Sorry!

I didn't noted that WH content is only for specified Code. Not for all WH!

That is mean, that SUM for one day will not take in to account WHcontent of Codes which do not have operation in this day.

To have right values of SUM for each day i need to add for this day WH content of all Codes, because of this i want to make script or formula to build time series of WH content for each Code & for each day.

Community Browser