Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Comparing dates

I can not make a comparison between two dates. The following snippet shows an example in detail:

"if(fine_anno=finemese,1, 0)"

where:

     fine_anno = 31/12/2016

     finemese = 31/12/2016

     -----------------------------------

     fine_anno = 31/12/2016

     finemese = 30/04/2016

By obtaining, for any comparison, always "0". Where am I doing wrong?

1 Solution

Accepted Solutions
sunny_talwar

May be try this:

If(Floor(fine_anno) = Floor(finemese),1, 0)

View solution in original post

2 Replies
trdandamudi
Master II
Master II

Hope this is what you are looking for:

Comparing_Dates_18_Jan_2017_01.jpg

Check you date formats as below:

Comparing_Dates_18_Jan_2017_02.jpg

sunny_talwar

May be try this:

If(Floor(fine_anno) = Floor(finemese),1, 0)