doubt

[#1]

this the exp for mtd or ytd

sum({<[Walkin Date]={'>=$(vMinDate)<=$(vMaxDate)'}>}Incount)+sum({<[Walkin Date]={'>=$(vMinDate)<=$(vMaxDate)'}>}OutCount))/2

[sunny_talwar]

It could be anything. Need to know what vMinDate evaluates to. I guess create a text box with $(vMinDate) and see what you get. If its MonthStart then its MTD, and if it is YearStart then its YTD

HTH

Best,

Sunny

[avinashelite]

can you please elaborate what doubt and error your facing, so   that it will be helpful for us to understand

[florentina_doga]

good answer

[giakoum]

Also check your Walkin Date field format. Is it the same as your variables? There is also a parenthesis missing

Qlik Community Tip: Posting Successful Discussion Threads

[sunny_talwar]

Thank you Florentina‌

[#7]

VMINDATE=MIN(DATE) AND VMAXDATE=MAX(DATE)

[sunny_talwar]

What do you get when you put this in a text box -> $(vMinDate). You should get a date, I want to know what date you get?

[#9]

if we select a month march its 1/03/2015 if we don't make an selection its 01/01/2015

[sunny_talwar]

So i guess your expression is YTD when nothing is selected and as soon as you make a selection, it changes to become MTD. Do you want it to be one or the other?

Best,

Sunny