topic Re: Variable is not woeking in Set Expression in QlikView

Variable is not woeking in Set Expression

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

Hi All,

I have a variable v1 =Max(CstDate);

However in set analysis I am trying to use below syntax and it is throwing error:

=sum({<CstDate ={'<=Date('$(v1)','M/D/YYYY')'}>}OrderLineDueCount)

Could anyone please help me on this.

Thanks,

Sarif

pokassov — Thu, 06 Apr 2017 04:53:21 GMT

=sum({<CstDate ={"<=$(=Date(v1,'M/D/YYYY'))"}>}OrderLineDueCount)

MK_QSL — Thu, 06 Apr 2017 06:16:47 GMT

Or try this

=SUM({<CstDate = {'>=$(=$(v1))'}>}OrderLineDueCount)

Anil_Babu_Samineni — Thu, 06 Apr 2017 06:28:09 GMT

May be typo error

=SUM({<CstDate = {'<=$(=$(v1))'}>}OrderLineDueCount)

saimahasan — Thu, 06 Apr 2017 06:47:12 GMT

Try with this. It worked for me

=Count({<CstDate={'<=$(v1)'}>}OrderLineDueCount)

Anonymous — Thu, 06 Apr 2017 12:54:51 GMT

Why you use a variable?

May be try to put directly the max in your set analysis expression?

sum({<CstDate ={$(=Max(CstDate))}>}OrderLineDueCount)