data is not loaded in to Qv App when i am using concatinate function

[Anonymous]

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.

[giakoum]

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

[#3]

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

[PrashantSangle]

Hi,

Try with Loading both table individually.

Will they give it any result??

Regards,

[Anonymous]

Hi all,

Thanks for your reply.

I got solution through preceding load i got solution.

Thanks,