Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
ankit28287
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
anantmaxx
Specialist
Specialist

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

ankit28287
Creator
Creator
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.

ankit28287
Creator
Creator
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.

anantmaxx
Specialist
Specialist

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

ankit28287
Creator
Creator
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.