variable issue

[#1]

Hi Experts,

I have to set variable for the following expression

'>=$(=Date(MonthStart(vMaxSalesDate)))<=$(=Date(vMaxSalesDate))'

when i give like

vCurrMnth='>=$(=Date(MonthStart(vMaxSalesDate)))<=$(=Date(vMaxSalesDate))'

it is giving error.

Pls help me to solve this

[#2]

Hi,

Monthyear is like MMM YYYY (jun 2015)

ok i removed it and used date alone.

date format is DD/MM/YYYY.

but still null values.

[#3]

Any other suggestions plssssssssssss

[sunny_talwar · Accepted solution]

Sorry I misread your earlier expression, it was correct if Date is DD/MM/YYYY then you had it right. Only other thing I can think of is to try it like this:

=SUM({<MonthYear=, Date={"$(vCurrMnth)"}>} DAYS)

[#5]

showing garbage after '<='

[sunny_talwar]

Hahahaha damn it man. Try this I guess:

=SUM({<MonthYear=, Date={"$(='>=' & Date(MonthStart(vMaxSalesDate)) & '<=' & Date(vMaxSalesDate)))"}>} DAYS)

[maxgro]

post your .qvw

or remove the label of your expression and try to find the problem looking at the popup as in image

[md_qlikview]

Yes you can verify your output as mentioned by Massimo. I have created this kind of variable once, but as per my knowledge i simply wrote this as below

'>=$(=Date(MonthStart(vMaxSalesDate)))<=$(=Date(vMaxSalesDate))'

[pratap6699]

LET vCurrMnth=>=$(=Date(MonthStart(vMaxSalesDate)))<=$(=Date(vMaxSalesDate))

=SUM({<Date={"=$(vCurrMnth)"}>} DAYS)