topic Re: Set Analysis in QlikView

Set Analysis

tripatirao — Fri, 18 Sep 2015 08:11:35 GMT

Hi All

I am having Sales data for year 2011,2012,2013.

I want to find YTD.

Can I use this expression.

YTD Sales (Year To Date)

Sum({<Year=, Quarter=, Month=, Week=, Date={‘>=$(=YearStart(Today()))<=$(=Today())’}>} Sales )

Fri, 18 Sep 2015 08:16:32 GMT

Hi,

i think it works,or else try with this

=sum({<Year={'<=$(=max(Year))'}>}sales)

lironbaram — Fri, 18 Sep 2015 08:17:29 GMT

yes

you can use this kind of expression

but it only work for 2015

Fri, 18 Sep 2015 08:19:06 GMT

Hi tripati,

As Liron said it works only for 2015.

jonathandienst — Fri, 18 Sep 2015 08:20:22 GMT

You want YTD data, I assume you also have data for 2015.

I suggest that you test the expression yourself on your data before asking whether it will work.

MK_QSL — Fri, 18 Sep 2015 09:17:17 GMT

YTD

SUM({<

Year =, Quarter = ,Month = , Week = ,

Date = {">=$(=YearStart(Today()))<=$(Today())"}

>}Sales)

YTD for selected Date

YTD

SUM({<

Year =, Quarter = ,Month = , Week = ,

Date = {">=$(=Date(YearStart(Max(Date))))<=$(=Date(Max(Date)))"}

>}Sales)

If you want to select Year and get the corresponding sales...

SUM({<

Date =, Quarter = ,Month = , Week = ,

Year = {"$(=Max(Year))"}

>}Sales)

sunilkumarqv — Fri, 18 Sep 2015 09:43:08 GMT

=sum({<Year={$(=Max(Year))},MonthID={'<=$(=max(MonthID))'},Month=>}sales)