Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME 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)