topic Re: Excel Targets Integration in QlikView

Excel Targets Integration

Anonymous — Tue, 24 Mar 2015 08:08:55 GMT

Dear All,

I am attaching excel sheet of target to data model with Master date.

When I concatenate, I gets the both date of Excel sheet and Master date as well.

But targets are not working with calender,

Say, I am having 01/Jan/2014 in Excel and same in Master date, If I selects 01/Jan/2014 of Excel sheet, I am getting tha data on excel sheet selection but not on master date.

I have tried all the Date formats but not getting the solution.

PFA of Excel targets.

Pls Suggest.

Regards,

Balraj

Re: Excel Targets Integration

Peter_Cammaert — Tue, 24 Mar 2015 08:15:30 GMT

See Excel Intergration Problem

Are the two of you working on the same problem?

Re: Excel Targets Integration

Anonymous — Tue, 24 Mar 2015 08:18:52 GMT

Nope,

Is it same scenario?

Re: Excel Targets Integration

Peter_Cammaert — Tue, 24 Mar 2015 09:55:07 GMT

110% the same, it seems.

Re: Excel Targets Integration

vikasmahajan — Wed, 15 Apr 2015 07:33:21 GMT

can you use this formula while loading in qlikview and try

Date(Num(Evaluate(Dates))) as Date,

Vikas