topic Re: Expression(WTD) in QlikView

Expression(WTD)

NavinReddy — Mon, 22 Jul 2013 06:09:35 GMT

Hi Community,

some one help me i need to be find out week to date calls,

my should be starts from sunday

sunday-till date how can i able to find out the cals(WTD)

thanks in advance

Rohith

tresB — Mon, 22 Jul 2013 06:23:06 GMT

try something like:

Count(if(inWeekToDate( CallDate,vToday,-1), Calls))

er_mohit — Mon, 22 Jul 2013 06:23:40 GMT

try this

WTD:

Count({<Date={'>=$(=(Num(WeekStart(Max(Date)))))<=$(=(Num(Date)))'}>}Calls)

or you can simply create a field in script

load Date, Sales ,

Weekstart(Date) as WeekStartDate From xyz.

Now use the WeekStartDate in your chart.

Hope the idea is clear.

NavinReddy — Mon, 22 Jul 2013 06:59:55 GMT

expression not working for me

Sunday -till date

thanks,

rohith