topic Can not use date function in set expression ? in QlikView

Can not use date function in set expression ?

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

Hi All,

I have a date field by the name DTM in my app, on searching for a particular date in list box i am able to find the field only after using '*' as shown in the attached.

I am using this field in a set expression and it is not returning values for matching DTM field value.

= Only({1< DTM = {"$(=vCurrentDt)"} >} Month)

so i decided to change the format of the field to date and that is providing error in expression.

= Only({1< date(DTM) = {"$(=vCurrentDt)"} >} Month)

I there any way that we can achieve this by making changes in application only and not data model.

Thanks,

Ganesh

Re: Can not use date function in set expression ?

sunny_talwar — Thu, 16 Mar 2017 14:49:19 GMT

What is vCurrentDt?

Re: Can not use date function in set expression ?

ganeshreddy — Thu, 16 Mar 2017 15:06:57 GMT

Hi Sunny,

The variable expression given below

vCurrentDt=if(GetSelectedCount(WorkingWeek2)=1,date#(date(WorkingWeek2+5),'M/D/YYYY'),num(Today()))

Re: Can not use date function in set expression ?

sunny_talwar — Thu, 16 Mar 2017 15:09:16 GMT

Not entirely sure, but may be this

=Only({1<DTM = {"=DTM = vCurrentDt"}>} Month)

=Only({1<DTM = {"=DTM = $(vCurrentDt)"}>} Month)