topic Re: Need Help with Expression in QlikView

Need Help with Expression

ramyasaiqv — Fri, 29 Sep 2017 04:23:25 GMT

I’m trying to calculate the number of Days the Oder is Open for the orders which have

Type= ‘BCT’ and Status=’Accepted’ (no ECT status at all) and Type=’ECT’ and Status=’Open’

Expression to count the number of orders which have Type= ‘BCT’ and Status=’Accepted’ (no ECT status at all) and Type=’ECT’ and Status=’Open’

Count({<[ID]=P({<[Type]={'BCT'},[Status]={Accepted}>})*
P({<[Type]={'ECT'},[Status]={Open}>+<[ID]={"=Count([ID]) = 1"},[Type]={'BCT'},[Status]={Accepted}>})>} DISTINCT [ID])

I’m trying to tweak this expression to get the number of Open Days and need help please help me.

# Days Open = (Today()- Date (Approved)

Please can someone help me with the expression.

Thank you,

Ramya

Re: Need Help with Expression

antoniotiman — Fri, 29 Sep 2017 05:07:58 GMT

Hi,

may be this

Today()-Only({<[ID]=P({<[Type]={'BCT'},[Status]={Accepted}>})*
P({<[Type]={'ECT'},[Status]={Open}>})+P({<[ID]={"=Count([ID]) = 1"}>})>} DISTINCT Date)-1

Regards,

Antonio

Re: Need Help with Expression

ramyasaiqv — Fri, 29 Sep 2017 17:10:31 GMT

Thank you Antonio, really appreciate it.

ramya

Re: Need Help with Expression

ramyasaiqv — Wed, 04 Oct 2017 04:41:50 GMT

Hi Antonio,

I'm sorry when i did complete testing my data i found some issue with the above expression. If you get a chance please can you help me with the attached.

Issue:

In the attached qvw there shouldn't any data for Orders PTC and Type= ECT because ECT status= Accepted and also Oder MEC, Type=BRD' and Status='Accepted'.

Requirement: calculate the number of Days the Oder is Open for the orders which have

Type= ‘BCT’ and Status=’Accepted’ (no ECT status at all) and Type=’ECT’ and Status=’Open’

I have attached the qvw, excel and expected result set. Please help me

Regards,

Ramya

Re: Need Help with Expression

antoniotiman — Wed, 04 Oct 2017 06:15:56 GMT

There's no 1100DESC in Your input data

Re: Need Help with Expression

ramyasaiqv — Wed, 04 Oct 2017 13:29:56 GMT

Hi Antonio,

Sorry it was my mistake it's 445 DESC, i have updated the corrected file. When you get a chance please help me. Thank you,

Ramya

Re: Need Help with Expression

antoniotiman — Wed, 04 Oct 2017 13:45:24 GMT

See Attachment

Re: Need Help with Expression

ramyasaiqv — Thu, 05 Oct 2017 01:30:59 GMT

Thank you so much Antonio.

Ramya