Sales for given year

Report Inappropriate Content · ‎2015-05-21

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 · ‎2015-05-21

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

regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

rakesh_kumar · ‎2015-05-21

Hi Sid,

Try something like this:

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

Regards,

RK

manojkulkarni · ‎2015-05-21

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

PrashantSangle · ‎2015-05-21

My bad i miss {}

Try below

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Related Topics