topic Re: Date range split in QlikView

Date range split

Mon, 19 Nov 2012 17:11:01 GMT

HI,

I was wondering if QlikView could solve the following problem?

I have the table:

Start Date End Date Spend

20-Sep-12 27-Sep-12 £4,200

28-Sep-12 01-Oct-12 £2,000

I would like to draw one bar for each day between start and end dates sized by an average spend per day

I reckon to do this I would need to convert the data into the following format:

Date Avg Daily Spend

20-Sep-12 £600

21-Sep-12 £600

22-Sep-12 £600

23-Sep-12 £600

24-Sep-12 £600

25-Sep-12 £600

26-Sep-12 £600

27-Sep-12 £600

28-Sep-12 £500

29-Sep-12 £500

30-Sep-12 £500

01-Oct-12 £500

Is it possible to do it in QlikView? If yes, could you help me with it, please?

Thanks

Clever_Anjos — Mon, 19 Nov 2012 17:14:57 GMT

Yes,

Please check your manual for IntervalMatch command

swuehl — Mon, 19 Nov 2012 17:17:28 GMT

Check for example John's solution here:

Regards,

Stefan

CELAMBARASAN — Mon, 19 Nov 2012 17:38:20 GMT

Hi,

I hope this is what you expected.

Check the attachment.