Discussion board where members can get started with QlikView.
How do you reduce data for a time period that overlaps two years?
October 2011 - February 2012.
Go to Solution.
Either You can do it in backend or can also do it in front-end.
Please find the attached app where I have shown you both the ways.
To do it in front-end you can simply take a list box and use expression in that list box for example Month&Year as expression in list box.
Also, Please make sure to keep backup as data reduction once done can not be over done. So take backup and also verify the data after reduction.
What do you mean by reduce data ?
Are you refering to the reduce data -> keep possible values ? Where we reduce the data which does not relate to current selections?
yes, that is what I am referring to.
You can do reduction based on Monthname field (Any field which contains both the Month and Year).
Monthname() fucntion can be used to generate this field. This funciton takes date as a input parameter.
Monthname(10-Oct-2011) will return Oct 2011 .
So, you have both the month and year information in a single field then in this field itself you can do selection for Oct 2011 to Feb 2012 and can reduce the data.
where would I input Monthname() to get this reduction?
in the script?
in the frontend somewhere?
How would I input the date range? like this:
Monthname(Oct-2011 - Feb-2012)
Perfect, thank you!