Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

concat

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...

9 Replies
Highlighted

Hi,

can you post your script..

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted
Not applicable

rename in load script,

month as (month1),

Hope this helps!

Highlighted
Anonymous
Not applicable

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

Highlighted
Partner
Partner

Hi,

Can you send me sample app?

Muthukumar Pandiyan
Highlighted
Not applicable

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

Highlighted
Specialist
Specialist

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

Highlighted
Creator II
Creator II

yes..

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

Highlighted
Not applicable

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

Highlighted
Creator II
Creator II

hi praesh

ca you give me the expression with sample.