topic Re: Expression Help in QlikView

Expression Help

Wed, 12 Feb 2014 07:56:07 GMT

Hi all,

I got this expression:
=SUM({1< Year = {$(=vStaticCY)}, Week = {$(=vStaticW)}, DivisionName = {'XXXX'}>} RevenueAmount)/1000

Now it shows me the max week of the max year. However is it possible to let me show the cumalative of week 1-6?

And that it keeps adding weeks untill the end of the year.

kind regards

Wed, 12 Feb 2014 08:11:46 GMT

Just do in the set:

Week={>$(=vStartWeek) <$(vEndWeek)}

to get all the weeks between start and end

See a doc I have written on Set Analysis: http://community.qlik.com/docs/DOC-4951

Fabrice

sujeetsingh — Wed, 12 Feb 2014 08:12:38 GMT

Use AGR() function

jagan — Wed, 12 Feb 2014 08:18:57 GMT

Hi,

Try this expression

=SUM({1< Year = {$(=vStaticCY)}, Week = {'<=6'}, DivisionName = {'XXXX'}>} RevenueAmount)/1000

or if you have variables for start and end week then use like this

=SUM({1< Year = {$(=vStaticCY)}, Week = {'>=$(=vStartWeek)<=$(=vEndWeek)'}, DivisionName = {'XXXX'}>} RevenueAmount)/1000

Hope this helps you.

Regards,

Jagan.