topic concat in QlikView

concat

raadwiptec — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have a QVD File with following columns.

Month,

Year,

Quarter,

AccountNo

Account Desc

in my existing QVW i already have month year and Quarter.

But when i include this Load from QVD in the script.

month,year and Quarter gets syntehtic.

I tried Forced concatenate but does not work.

any suggestions...

PrashantSangle — Wed, 06 Jul 2016 08:35:41 GMT

Hi,

can you post your script..

Regards,

Wed, 06 Jul 2016 08:36:11 GMT

rename in load script,

month as (month1),

Hope this helps!

Anonymous — Wed, 06 Jul 2016 08:46:32 GMT

use a mastercalendar and define a datefield to connect to your different tables

muthukumar77 — Wed, 06 Jul 2016 11:05:09 GMT

Hi,

Can you send me sample app?

Wed, 06 Jul 2016 11:13:22 GMT

Have you tried joining the tables and checking the info density in table viewer. this would help ascertain perhaps format issues, etc.

tyagishaila — Wed, 06 Jul 2016 11:43:41 GMT

Doesn't work means, Do you still have synthetic keys?

raadwiptec — Wed, 06 Jul 2016 11:53:05 GMT

yes..

the problem also is the existing month is 01.02 format.. and the one which loads from QVD is jan,feb,mar..

Wed, 06 Jul 2016 11:57:01 GMT

use the date# function to format the dates as you desire and your problem should be solved

raadwiptec — Wed, 06 Jul 2016 13:16:35 GMT

hi praesh

ca you give me the expression with sample.