Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I wrote following code in Qlikview
code:
load 'Long Calls' as desc,CallDate_Date as mon, num(count(CALLINFO_SESSIONID),'#,##0.00;(#,##0.00)') as measure
resident test
where IVR_Duration2>=6
group by CallDate_Date;
Concatenate
load 'Short Calls' as desc,CallDate_Date as mon, num(count(CALLINFO_SESSIONID),'#,##0.00;(#,##0.00)') as measure
resident test
where IVR_Duration2<6
group by CallDate_Date;
when i reload the application it loads only short calls fields data it does not loads long calls data .
Please help me.
code looks ok.
you do not need to concatenate the 2 tables. They will be concatenated anyway as they have same fields.
so try this :
table1:
load 'Long Calls' as desc,CallDate_Date as mon, num(count(CALLINFO_SESSIONID),'#,##0.00;(#,##0.00)') as measure
resident test
where IVR_Duration2>=6
group by CallDate_Date;
table2:
load 'Short Calls' as desc,CallDate_Date as mon, num(count(CALLINFO_SESSIONID),'#,##0.00;(#,##0.00)') as measure
resident test
where IVR_Duration2<6
group by CallDate_Date;
If that does not work then you should check your data. Maybe there is none with IVR_Duration2>=6
Try running only for 'Long Calls' and see if you get any result set in return. As my fellow members stated that it can be case where you do not have data for IVR_Duration2>=6
Hope this was helpful.
Thanks,
Singh
Hi,
Try with Loading both table individually.
Will they give it any result??
Regards,
Hi all,
Thanks for your reply.
I got solution through preceding load i got solution.
Thanks,