Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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)