Set Analysis - Pipeline

[#1]

Hello,

I am looking to put in some set analysis in my dashboard.  The field I want to use is ORDERVALUE, and I want to see the value of opportunities we have pending as of say today or this month onwards.   Can anyone advise of the expression that will be used?

Many thanks

[MK_QSL]

SUM({<Opportunity = {'Pending'}, Date = {'>=$(=Date(Today()))'}>}ORDERVALUE)

[senpradip007]

Hi Members.

Being an active member i can't understand why people use to copy & post the same solution made by an other member previously on that topic. Its a request from my side to the members not to copy & post the same.

Warm Regards.

PS

[dirk_konings]

They want to score some points or reply via email ?

Dirk

[MK_QSL]

QlikView Community is not only for making points !

This is a great site to learn more and more but members need to be understood this.