topic Re: Trend Chart in QlikView

Trend Chart

Fri, 22 Mar 2013 12:30:05 GMT

HI All,

I have a requirement where it should show current trend and the last month's trend in a single chart.

Can any one please help in this..

Thanks

Re: Trend Chart

alexandros17 — Fri, 22 Mar 2013 12:39:24 GMT

Please send me your example and I'll try to help

Re: Trend Chart

Fri, 22 Mar 2013 13:33:00 GMT

my query is something like

Facts:

LOAD "call_date" as call_date1,

fnf,

idd

FROM

(qvd);

PIE_TBL:

CrossTable(PRODUCT,VALUE)

LOAD "call_date",

"idd" as "IDD" ;

Facts:

LOAD

call_date,

idd,

FROM

(qvd);

[AsOf]:

LOAD

call_date1 as AsOfDttm1,

DATE(Subfield(DATE(call_date1),' ',1)) as AsOfDttm_Day,

MonthName(call_date1) as AsOfDttm_Month,

'Current' as PreviousCurrentFlag;

LOAD DISTINCT call_date1

RESIDENT Facts;

CONCATENATE ([AsOf])

LOAD

call_date1 as AsOfDttm1,

addmonths(call_date1,-1) as call_date1,

'1mback' as PreviousCurrentFlag;

LOAD DISTINCT call_date1

RESIDENT Facts;

Re: Trend Chart

Fri, 22 Mar 2013 13:35:35 GMT

and in the graph i need date on dimension and trend on expression (line)

In expression: one should be current month and the other one 1 month before's trend..

Is this information ok.. please let me know if u need more..

Its very urgent.. I need to do it in an hour ..

please help