Insert Value between dates which are not available in database

[#1]

Hi

I have data in data source like below:

Product      SalesDate     Value

A               01-01-2012     $100

A               01-04-2012     $50

So there is no sale in Feb-12 and Mar-12,But the requirement is to show.

Product     Date

A               01-01-2012     01-02-2012     01-03-2012     01-04-2012

                    $100               $0               $0                    $50.

Kindly help me.

Regards

Aaron

[CELAMBARASAN]

Maintain separate calendar for this type of requirements which is generated by your own.

There is lots of code to generate master calendar available in community post search for it.

Refer this

http://community.qlik.com/thread/48693

[shree909]

u can use inline table  if u have less values

if you  have more data than either u need to request from ur database team to proide the dates with 0 value OR do  hardcoding the values...

[its_anandrjs]

Hi,

Use autogenerate for date generation

Regards,

Anand

[#5]

Hi Ajmal,

As Shree Sai, you can use the Inline and add the dates ,if their are less record otherwise you need to add at the database side only.

Regards,

Ramesh

[Gysbert_Wassenaar]

Attached is a simple example. I hope this helps you find the answer to your question.

[its_anandrjs]

Hi,

Create table like this

Let varMinDate = Num(Makedate(2012,1,1));

Let varMaxDate = Num(Makedate(2012,1,4));

load

date($(varMinDate)+IterNo()-1) as SalesDate

AutoGenerate (1)

While $(varMinDate)+IterNo()-1 <= $(varMaxDate);

Temp:

load * inline

[

Product,SalesDate,Value

A, 01/01/2012,  $100

A, 01/04/2012,  $50

];

HTH

Regards,

Anand

[#8]

Thanks Everyone..its very helpful to me