topic Re: Range Expression in QlikView

Range Expression

kunkumnaveen — Fri, 15 Dec 2017 08:29:30 GMT

Hi,

Currently we are in FY-2018,December Month ,so if FY-2017 is selected then I need to consider entire year volume (Apr to March),

if FY-2018 is selected then I need to consider only 8 months volume (Apr-Nov),December month volume should not be considered ,In January month ,till December volume I need to considered ....so on

How to write this expression Dynamic from below data

CAL MONTH is derived from a date field as below

Month(CALDAY) as "CAL MONTH"

CALDAY is in DD-MM-YYYY formate

Thanks

Re: Range Expression

Anil_Babu_Samineni — Fri, 15 Dec 2017 08:43:20 GMT

First you need to create Fiscal Calendar which starts from Apr (4) -- Mar (3) as FY2017-18 ..

Re: Range Expression

kunkumnaveen — Fri, 15 Dec 2017 09:13:06 GMT

Well ,I had already derived fiscal year from Calendar date ,for example if I select FY2018 ,then It will select

Calendar date from 01-04-2017 to till date value

Re: Range Expression

big_dreams — Fri, 15 Dec 2017 09:17:26 GMT

Sum({<CALDay={"<$(=date(MonthStart(Today()))"}>}Volume)

Regards,

Re: Range Expression

Anil_Babu_Samineni — Fri, 15 Dec 2017 09:19:19 GMT

Try, this is the case i would use below one. Min(FiscalMonth) shows Apr.

Sum({<FiscalYear = {">=$(=MonthStart(Min(FiscalMonth))) <=$(=Max(DateField))"}>} Sales)

Re: Range Expression

sunny_talwar — Fri, 15 Dec 2017 10:05:39 GMT

May be like this

=If(Max({1} TOTAL [Fiscal Year]) = Max([Fiscal Year]), Sum({<CALDAY = {"$(='<' & Date(Max(CALDAY), 'DD-MM-YYYY'))"}>}VOLUME), Sum(VOLUME))