Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Date field coming as General value in qlik

I have a Dates of each month in the column

When i am loading the date it is coming as a general value.

I tried changing the excel format to date. Still it is coming as a general value.

Please see the date image of the excel and QLik sense

20 Replies
sunny_talwar

May be this

Sum({1<Billing_Date={">=$(=Date(YearStart(Max(Billing_Date),-2)))<$(=Date(MonthStart(AddYears(Max(Billing_Date), -2), 1)))"}, Year1={"2016"}>} value)