Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Set Analysis - Pipeline


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

4 Replies

Re: Set Analysis - Pipeline

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

senpradip007
Valued Contributor III

Re: Set Analysis - Pipeline

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
Contributor III

Re: Set Analysis - Pipeline

They want to score some points or reply via email ?

Dirk

Re: Set Analysis - Pipeline

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.

Community Browser