Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression in pivot returning 0

Hi,

In my script I define month_num1 and month_num3 as following:

year(Date(AddMonths(Date(([Reporting Date]),1)))  * 100 + num(month(Date#(month(Date(AddMonths(Date([Reporting Date]),1))) 'MMM'))) as  month_num1

year(Date(AddMonths(Date([Reporting Date]),1))) 3))) * 100 + num(month(Date#(month(Date(AddMonths(Date([Reporting Date]),1))) ,3))),'MMM'))) as  month_num3

The following expression:

sum({1<ITEM={"Known Mvmt"},forecast_month_num={">=month_num1 <=201309"}>} FTE) is returning the correct figures.

When replacing 201309 by month_num3 in the expression as following it returns 0. The month_num3 is correcty filled in the load.

sum({1<ITEM={"Known Mvmt"},forecast_month_num={">=month_num1 <=month_num3"}>} FTE) is returning 0.

Any idea,

Thanks

0 Replies