topic Problem with relations in QlikView

Problem with relations

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

what am I doing wrong though I get two types of period, one from the budget and one from Fakturor/Calendar1?

I´m not able to show values from the budget and sales at the same time, see attached qv. !

Anonymous — Wed, 09 Nov 2016 11:06:57 GMT

your Period from Budget2016 is recognized as text (left aligned) while theother field Period contain dateformat (right aligned)

you Need to Format Period from Budget2016 as date using date#(Period,'YYYYMM')

Wed, 09 Nov 2016 12:10:58 GMT

Hello again,

but Period comes fron the CrossTable: CrossTable(Period,Amount)

I have tried to format this like CrossTable(date#(Period,'YYYYMM'),Amount) but this doesn´t work.

Anonymous — Wed, 09 Nov 2016 12:41:00 GMT

then try to load the table again

load into temporary table

Tmp:

load date#(Period,'YYYYMM') as Period,

other field

resident Budget2016;

drop table Budget2016;

rename table Tmp to Budget2016;

Wed, 09 Nov 2016 12:47:07 GMT

I made it with a temporary table and load resident.

Thanks for all help.

Håkan