How to Generate missing Date

[Vinod]

Hi All.

How to generate missing dates in QlikView. I have attached simple dataset for Reference.

Please any one give me solution.

Regards,

Vinod.

[pooja_prabhu_n]

Hi,

Try this

if(Len(Trim(ID))=0, Peek(ID),ID) as ID,

If you want just Random number use Rand() function like below

if(Len(Trim(ID))=0, Rand(),ID) as ID,

Please find the updated qvw file

Thanks,

Pooja

[Vinod]

Thank You, It's working fine for the sample data shared. But when i used with my actual data I got result as in the attached file.

[pooja_prabhu_n]

Hi,

I tried with Data.xls for that it is working fine.

Can you share some sample data scenarios for which you are facing issue.

[Vinod]

Hi.Can you please send me the qvw file.

[pooja_prabhu_n]

PFA

[Vinod]

Thank You.