Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Expression to Calculate - Opportunity WIP(From History), vDays(a variable return Integer) Back from Today.

Expression to Calculate - Opportunity WIP(From History), vDays(a variable return Integer) Back from Today.

Please check attachments.

6 Replies
Anonymous
Not applicable
Author

hi ankit ,

before answering i want to make it clear is that what i understood you want

do you want to enter no of days like 30,15,25 etc  from a input box

and you need opportunity wise op-123 ,op-124 and whatever opportunity size wise back from today?

anant

sujeetsingh
Master III
Master III

Ankit please explain what you want

Anonymous
Not applicable
Author

rightly sail from input box i want to enter Days(integer values) like i selected 15.

eg -for opportunity - OP-123 , on 16-12-2013(by Exp- Today()-15) WIP stage was WIP 5.

So 15 days back for OP-123 WIP stage was WIP 5

and for OP-124 WIP Stage was WIP 4

now if i change vDays to 30.(on date 01/12/2013)

Than for OP-123 WIP stage is - WIP 3

for OP-124 WIP Stage is - WIP 3

i think that will help you understand my case.

Anonymous
Not applicable
Author

I am trying to explain it via example please also check my attachment as that will help you to understand the case.

eg -for opportunity - OP-123 , on 16-12-2013(by Exp- Today()-15) WIP stage was WIP 5.

So 15 days back for OP-123 WIP stage was WIP 5

and for OP-124 WIP Stage was WIP 4

now if i change vDays to 30.(on date 01/12/2013)

Than for OP-123 WIP stage is - WIP 3

for OP-124 WIP Stage is - WIP 3

i think that will help you understand my case.

Anonymous
Not applicable
Author

Hi,

i used the following script at script level

Temp1:

LOAD

       Opporunity,

      [Opps stage],

      Date,

   Date(If(IsNum( Date),Date, $(#vBeginTime))) as FromDate

   

FROM

(ooxml, embedded labels, table is [Opps History]);

OPP:

LOAD

Opporunity,

[Opps stage],

FromDate,

Date(If( Opporunity=Peek( Opporunity),Peek(FromDate)-0.00000001, $(#vEndTime))) as ToDate

RESIDENT Temp1 Order by  Opporunity, FromDate desc ;

DROP Table Temp1;

created a variable vdate attached to input box that will recevie your integer.

and fdate=today()-vdate      that will filter WIP AND Opputunity listbox

use two list box one for WIP and another for Oppurtunity

then in each listbox expression write  the following expression:

=if(fdate>FromDate and fdate < ToDate,Opporunity)

when you enter a integer through input box vdate will receive and fdate variable  will check

in recpective list box.

please see attachment

anant

Anonymous
Not applicable
Author

I think it can work but i want that to work in expression of chart for further Comparison purpose while when i used this expression it provide Multiple values due to which expression show nothing as Multiple value issue occured.

please will you help me how i can use same in Chart.