topic Insert Value between dates which are not available in database in QlikView

Insert Value between dates which are not available in database

Fri, 16 Nov 2012 18:46:00 GMT

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

Re: Insert Value between dates which are not available in database

CELAMBARASAN — Fri, 16 Nov 2012 18:51:09 GMT

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

Re: Insert Value between dates which are not available in database

shree909 — Fri, 16 Nov 2012 18:51:36 GMT

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...

Re: Insert Value between dates which are not available in database

its_anandrjs — Fri, 16 Nov 2012 18:54:57 GMT

Hi,

Use autogenerate for date generation

Regards,

Anand

Re: Insert Value between dates which are not available in database

Fri, 16 Nov 2012 19:18:34 GMT

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

Re: Insert Value between dates which are not available in database

Gysbert_Wassenaar — Fri, 16 Nov 2012 19:21:18 GMT

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

Re: Insert Value between dates which are not available in database

its_anandrjs — Fri, 16 Nov 2012 19:35:42 GMT

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

Re: Insert Value between dates which are not available in database

Sat, 17 Nov 2012 09:00:07 GMT

Thanks Everyone..its very helpful to me