Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

chrisgoudy
New Contributor II

How do you reduce data for a time period that overlaps two years?

How do you reduce data for a time period that overlaps two years?

October 2011 - February 2012.

1 Solution

Accepted Solutions
Not applicable

Re: How do you reduce data for a time period that overlaps two years?

Hi,

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.

..

Ashutosh

6 Replies
Not applicable

How do you reduce data for a time period that overlaps two years?

Hi,

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?

..

Ashutosh

chrisgoudy
New Contributor II

How do you reduce data for a time period that overlaps two years?

Ashutosh

yes, that is what I am referring to.

Not applicable

Re: How do you reduce data for a time period that overlaps two years?

Hi,

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.

..

Ashutosh

chrisgoudy
New Contributor II

How do you reduce data for a time period that overlaps two years?

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)


Not applicable

Re: How do you reduce data for a time period that overlaps two years?

Hi,

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.

..

Ashutosh

chrisgoudy
New Contributor II

How do you reduce data for a time period that overlaps two years?

Perfect, thank you!

Community Browser