Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
Specialist
Specialist

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

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

Highlighted
Master III
Master III

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

Ankit please explain what you want

Highlighted
Creator
Creator

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

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.

Highlighted
Creator
Creator

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

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.

Highlighted
Specialist
Specialist

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

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

Highlighted
Creator
Creator

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

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.