topic Re: Expression in QlikView

Expression

NavinReddy — Fri, 13 Jun 2014 22:34:16 GMT

Hi Guys Help some one ,im not getting any error with expression

but its not working please any help

=sum({<Month={">=$(=date(YearStart(Today()),'MMMM'))<=$(=date(MonthStart(Today()),'MMMM'))"}>}Actuals)

any error in this expression im calculating YTD

Thanks In Advance

Niranjan

Re: Expression

PrashantSangle — Sat, 14 Jun 2014 08:39:42 GMT

Hi,

If possible can you share sample app??

Regards,

Re: Expression

swuehl — Sat, 14 Jun 2014 08:50:11 GMT

Niru Niru, isn't that question close to the question in your other thread:

YTD

Please avoid multiple threads. You already got answers in your other thread, and I am missing a response to my answer there.

Re: Expression

MK_QSL — Sat, 14 Jun 2014 10:14:56 GMT

Hi Niru,

Instead of lengthy set analysis calculation, you can add a simple YTD flag, below your date field to get the YTD in your UI side.

small example is given below

=====================

Sales:

Load

Date(Date) as Date,

Sales,

If(InYearToDate(Date,Today(),0) = -1,1,0) as YTDFlag

Inline

[

Date, Sales

08/09/2013, 80

10/12/2013, 100

16/01/2014, 200

22/02/2014, 220

24/04/2014, 100

29/05/2014, 120

14/06/2014, 1000

];

===========================

Now you can use as below

=SUM({<YTDFlag = {1}>}Sales)

Re: Expression

NavinReddy — Mon, 16 Jun 2014 09:17:48 GMT

Hi Max dreamer,

Please find the attechment

i not able to find the answer could you please help me to do this

Best Regards,

Niranjan