topic QV Expression? in QlikView

QV Expression?

Wed, 15 Jan 2014 05:42:53 GMT

I am Using Indian financial Year as 2012-2013 (From Apr 2012 to March 2013)

and 2013-2014 (From Apr-2013 to March 2014)

Now If I select both year same time and if i select Mar and Apr, It will return me output as --Apr 2012, Apr 2013, Mar 2013

But I need in such case it should return me output as Apr 2013, Mar 2013

Then what will be my expression ?

Thanks---

Wed, 15 Jan 2014 05:54:49 GMT

Hi Patel,

What is your Selection filter..Is it MonthYear?

If you want to see the result from April 2012 to March 2013 then you have to use rolling Month to calculate the same based on selection..

Thanks,

Selvakumar

Wed, 15 Jan 2014 07:20:17 GMT

can you please attach a sample file with expected results.