topic Re: Set Analysis Expression in QlikView

Set Analysis Expression

Tue, 22 Sep 2015 07:41:58 GMT

Hi,

Having the year format as in the attachment , how to fetch previous year data using the same year field in set analysis of an expression.

Thanks in advance

Anonymous — Tue, 22 Sep 2015 07:44:56 GMT

hi veena

Please try:

Sum({<DATE={"$(=Date(AddYears(DATE,-1)))"}>}AMOUNT)

Digvijay_Singh — Tue, 22 Sep 2015 07:49:13 GMT

Do you mean you need to select 2010 from your year field '2010-2011'? Something like that

{<Year={$(=subfield('2010-2011','-',1)}>}

SreeniJD — Tue, 22 Sep 2015 07:53:12 GMT

Hi Veena

You can have two additional date columns by converting the year(which is string here) as mentioned below...

2013-2014

left(fyear,4)... which gives you 2013

right(fyear,4).. will gives you 2014

use these expresssions, in your set analysis to get the desired analysis...

If you need more help, send me your sample qvw, I will provide the solution.

Regards,

Sreeni

Kushal_Chawda — Tue, 22 Sep 2015 08:10:39 GMT

if you have calculated the YearName as yearname(Date,0,4), you can use below set expression

=sum(DISTINCT {<YearName={"$(=yearname(max(YearName)-1,0,4))"}>}Value)

Tue, 22 Sep 2015 08:11:01 GMT

Hi Veena,

use like this:

Sum({<YEAR_FIELD_NAME={'$(=Left(YEAR_FIELD_NAME,4))'}>} SALE_AMOUNT)

Regards

Gennaro

Tue, 22 Sep 2015 10:02:53 GMT

I got it resolved. Thanks everyone!

Digvijay_Singh — Tue, 22 Sep 2015 10:39:24 GMT

Please close the thread by marking appropriate replies answered,helpful. Thanks!