Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I have a table with promotional period details as below.
Promotion Date From Date To
August 01/08/2015 31/08/2015
Wkend Madness 01/10/2015 3/10/2015
I want to effectively set variables for the date from and date to fields so that when a user clicks on 'Wkend Madness' in a listbox, the variables are populated with the matching columns so that at a click of a button they can look at data relating to those promotional periods.
Any advice?
Dave.
No one?
I would try in a different way, so you can click on Promotion and filter the date without variables and button click
Promo:
load * inline [
Promotion , FromDate , ToDate
August , 01/08/2015 , 31/08/2015
Wkend Madness , 01/10/2015 , 3/10/2015
];
Promo_x_Dates:
Load
Promotion,
Date( FromDate + IterNo() -1) as ReferenceDate
Resident Promo
While IterNo() <= ToDate - FromDate + 1 ;
Fact:
load
date(makedate(2015) + floor(rand()*365)) as ReferenceDate,
rand()*100 as Sales
AutoGenerate 1000;