Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kunkumnaveen
Specialist
Specialist

Range Expression

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

Capture.PNG

CAL MONTH is derived from a date field as below

                                                                     Month(CALDAY) as "CAL MONTH"

CALDAY is in DD-MM-YYYY formate

Thanks

5 Replies
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
kunkumnaveen
Specialist
Specialist
Author

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

big_dreams
Creator III
Creator III

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

Regards,

Anil_Babu_Samineni

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

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sunny_talwar

May be like this

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