topic Re: doubt in QlikView

doubt

Tue, 07 Jul 2015 13:01:52 GMT

this the exp for mtd or ytd

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

Re: doubt

sunny_talwar — Tue, 07 Jul 2015 13:09:57 GMT

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

Re: doubt

avinashelite — Tue, 07 Jul 2015 13:11:59 GMT

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

Re: doubt

florentina_doga — Tue, 07 Jul 2015 13:13:11 GMT

good answer

Re: doubt

giakoum — Tue, 07 Jul 2015 13:13:38 GMT

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

Re: doubt

sunny_talwar — Tue, 07 Jul 2015 13:13:53 GMT

Thank you Florentina‌

Re: doubt

Tue, 07 Jul 2015 18:27:13 GMT

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

Re: doubt

sunny_talwar — Tue, 07 Jul 2015 18:35:22 GMT

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?

Re: doubt

Wed, 08 Jul 2015 06:25:10 GMT

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

Re: doubt

sunny_talwar — Wed, 08 Jul 2015 09:56:47 GMT

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