topic Re: converting weekly values to daily in QlikView

converting weekly values to daily

Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I have a table with values at weekly basis which is something like

I have to perform some daily calculations so I want to load this as a daily table with values converted to daily (divide by 7) such as

I do not specifically have to load this in this manner as long as I can perform daily calculation within the script if there is a way.

Can anyone help me with this?

Please note that I am using personal edition so I would not be able to open qvd files.

thanks,

Manoj Agrawal

sunny_talwar — Wed, 10 Aug 2016 16:59:20 GMT

May be this:

Table:

LOAD item,

Date([week start date] + IterNo() - 1) as Date,

value/7 as value

While IterNo() <= 7;

LOAD item,

[week start date],

value

FROM

[https://community.qlik.com/thread/228671]

(html, codepage is 1252, embedded labels, table is @1);

Wed, 10 Aug 2016 17:57:22 GMT

Man, I have been using QlikView for a while but where do you learn to write scripts like these? 🙂

Works great. Thanks!