Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
akriaviaan
Contributor III
Contributor III

How to restrict a Date and year values in an expression

Hi All,

I want to calculate a KPI for  ...  Sum(Value).

The required o/p is

1)Sum of Value for entire Current year and upto previous month

=num(sum({<CalendarDate={'<=$(v_MaxMonth)'},AC_FiscalYear={'2017'}>}Value),'#,##0')

  2)Sum of Value for Current year previous month.

=sum({<FiscalYear={'2017'},CalendarDate  = {$(= Max([CalendarDate (#)]), -1)},CalendarDate=>}Value)

I used the above formulas are not working.

Cann any one help on this.

11 Replies
akriaviaan
Contributor III
Contributor III
Author

Thanks Sunny, it is working as expected.

sunny_talwar

If you are satisfied with the response, please close the thread by marking the correct response and any helpful responses.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny