Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
gauravgg
Contributor

Make data date wise

Hi

I have the following table

Budget:

load * inline

[

Plant,Month ,Value,Year

P1,Jan,100,2016

P1,Feb,100,2016

P1,Mar,100,2016

P1,Apr,100,2016

P1,May,100,2016

P1,Jun,100,2016

P1,Jul,100,2016

P1,Aug,100,2016

P1,Sep,100,2016

P1,Oct,100,2016

P1,Nov,100,2016

P1,Dec,100,2016

];

the above budget table by month

I want to make it day wise data i.e i have sum up the Value and divide by 365 (sum(Value)/365) and group  by Plant

Tags (1)
1 Reply
vinieme12
Esteemed Contributor II

Re: Make data date wise

LOAD Plant,

     Year

     Sum(Value)/365 as DailyAverage

From XXXx

Group by Plant,Year;