topic How to write chart expression in background script ? in QlikView

How to write chart expression in background script ?

Fri, 05 Aug 2011 08:00:11 GMT

Dear all,

I have huge expression in chart, due to which the chart is taking lot of time to load.

I need to write the same expression in backend script. How to do it?

This is the expression that is needed to be in backend script

Count(distinct if(Num(SLA_MISSED_DATE)<Num(CalendarMonthStart),

IF(CALL_REQ_OPEN_DATE < TIMESTAMP(CalendarMonthStart),

If(LEN(CALL_REQ_RESOLVE_DATE1)<1 or CALL_REQ_RESOLVE_DATE1 >TIMESTAMP(CalendarMonthStart),

IF(INCIDENT_STATUS<>'Cancelled' or (INCIDENT_STATUS='Cancelled' AND CALL_REQ_CLOSE_DATE >TIMESTAMP(CalendarMonthStart)),

IF(INCIDENT_STATUS<>'Closed' or (INCIDENT_STATUS='Closed' AND CALL_REQ_CLOSE_DATE >CalendarMonthStart),

IF(INCIDENT_STATUS<>'Closed-Unresolved' or (INCIDENT_STATUS='Closed-Unresolved' AND CALL_REQ_CLOSE_DATE >CalendarMonthStart)

,CALL_REQ_REF_NUM)))))))

Here CalendarMonthStart is calendar island, Which was created by me.

Thanks in advance.

Cheers,

Amay Patil

How to write chart expression in background script ?

Fri, 05 Aug 2011 10:47:07 GMT

Hi all,

Anyone please help on this?

Thanks in advance.

Cheers,

Amay Patil

How to write chart expression in background script ?

SunilChauhan — Fri, 05 Aug 2011 12:43:10 GMT

hope this help u

If(LEN(CALL_REQ_RESOLVE_DATE1)<1 or CALL_REQ_RESOLVE_DATE1 >TIMESTAMP(CalendarMonthStart),1) as Flag1

IF(INCIDENT_STATUS<>'Cancelled' or (INCIDENT_STATUS='Cancelled' AND CALL_REQ_CLOSE_DATE >TIMESTAMP(CalendarMonthStart),1) as Flag2,

IF(INCIDENT_STATUS<>'Closed' or (INCIDENT_STATUS='Closed' AND CALL_REQ_CLOSE_DATE >CalendarMonthStart) ,1) as Flag3

IF(INCIDENT_STATUS<>'Closed-Unresolved' or (INCIDENT_STATUS='Closed-Unresolved' AND CALL_REQ_CLOSE_DATE >CalendarMonthStart),1) as Flag4

and now write at front end

Count(distinct if(Num(SLA_MISSED_DATE)<Num(CalendarMonthStart),

IF(CALL_REQ_OPEN_DATE < TIMESTAMP(CalendarMonthStart),

If(Flag1=1,

IF(Flag2=1,

IF(Flag4=1,

IF(Flag3=1
,CALL_REQ_REF_NUM)))))))

How to write chart expression in background script ?

Mon, 08 Aug 2011 07:19:05 GMT

Hi Sunil,

Thanks for reply.

But still not able to do it,Since CalendarMonthStart and CALL_REQ_RESOLVE_DATE1 doesnt have any link.

Both are from different islands.

So how do i write the same in backend?

Cheers,

Amay Patil

How to write chart expression in background script ?

SunilChauhan — Mon, 08 Aug 2011 07:40:14 GMT

can u share sample