Re: Date range split - Qlik Community

Report Inappropriate Content · ‎2012-11-19

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 · ‎2012-11-19

Yes,

Please check your manual for IntervalMatch command

swuehl · ‎2012-11-19

Check for example John's solution here:

Regards,

Stefan

CELAMBARASAN · ‎2012-11-19

Hi,

I hope this is what you expected.

Check the attachment.