Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I expand a list of span days with values?
For example
11/01/2011, 1
11/05/2011, 5
11/12/2011, 10
11/20/2011, 20
11/30/2011, 3
should expand into these values
11/01/2011, 1
11/02/2011, 1
11/03/2011, 1
11/04/2011, 1
11/05/2011, 5
11/06/2011, 5
11/07/2011, 5
11/08/2011, 5
11/09/2011, 5
11/10/2011, 5
11/11/2011, 5
11/12/2011, 10
11/13/2011, 10
11/14/2011, 10
11/15/2011, 10
11/16/2011, 10
11/17/2011, 10
11/18/2011, 10
11/19/2011, 10
11/20/2011, 20
11/21/2011, 20
11/22/2011, 20
11/23/2011, 20
11/24/2011, 20
11/25/2011, 20
11/26/2011, 20
11/27/2011, 20
11/28/2011, 20
11/29/2011, 20
11/30/2011, 3
thanks,
James
This question was picked and answered in a separate thread
http://community.qlik.com/message/173239#173239
thanks,
James