topic Re: Creating daily target in QlikView

Creating daily target

hamdaniahmad — Mon, 15 Feb 2016 10:43:42 GMT

Dear QlikView Master,

I'm analyze data for a daily target, but my problem is the data provide by monthly,

if I divide by total days total will not same with original target (+ or -).

I tried to use div function and mod function, but I have problem in result to divide by daily.

Example :

Month = Jan 16 (31 Days)

Sales Target = 70

div(70,31) = 2

mod(70,31) = 8 <<< How to give out this result into 1 - 8 first days?

My Expectations :

Anyone can help me?

Thanks anyway

PradeepReddy — Mon, 15 Feb 2016 18:10:43 GMT

this is not the good thing, showing month level data in day level...

However the bellow script may helps you..

Load *,

if(day(Date_Field)<=8, mod((Sales Target), Ceil(MonthEnd(Date_Field())-MonthStart(Date_Field()))),

div((Sales Target), Ceil(MonthEnd(Date_Field())-MonthStart(Date_Field())))) as Daily_Target

From Source;

Ceil(MonthEnd(Date_Field())-MonthStart(Date_Field()))) --> will give you no of days in a month