topic Re: how to display date field values conditionally? in QlikView

how to display date field values conditionally?

Akina0929 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have one date field,I want to display in that field

if the date field value is lastmonth, it has to display same date

else condition '-'

sushil353 — Thu, 16 Mar 2017 04:17:43 GMT

Try this:

if(Month(DateField) = Month(Addmonths(today(),-1),DateFiled,null())

Akina0929 — Thu, 16 Mar 2017 05:25:07 GMT

Hi sushil,

it,s showing error.

rahulpawarb — Thu, 16 Mar 2017 05:38:21 GMT

Hello AB,

Month function takes 1 parameter. Corrected the expression to add closing bracket for month function.

//Old Code:

=if(Month(saledate) = Month(AddMonths(Today(),-1), saledate, null())

//New Code:

=if(Month(saledate) = Month(AddMonths(Today(),-1)), saledate, null())

Hope this will be helpful.

Regards!

Rahul