topic Re: Sales for given year in QlikView

Sales for given year

Thu, 21 May 2015 10:25:06 GMT

Hi Im attempting to use set analysis to see sales for a given year in this case 2012.

My expression is :

=$(vSumSales)

What would the correct syntax be ?

Thanks

PrashantSangle — Thu, 21 May 2015 10:36:08 GMT

Sum({<Year="2012">}Sales)

regards

rakesh_kumar — Thu, 21 May 2015 10:39:10 GMT

Hi Sid,

Try something like this:

=Only({$<Year={2012}>} Sales)

Regards,

manojkulkarni — Thu, 21 May 2015 10:43:15 GMT

Sum({<Year={'2012'}>}Sales)

PrashantSangle — Thu, 21 May 2015 10:44:52 GMT

My bad i miss {}

Try below

Sum({<Year={"2012"}>}Sales)

Regards