Problem with "Year" dimension after cross table in Qlik Sense

[Xabinav]

Hi,

After i did cross table (from excel file) i noticed that  "Year" dimension from Budget table and Calendar table did not connect properly.

this is the script (ignore "Region")

this how it look at Sense - Budget "Year" on the left /  Calendar"year" on the right

How can I connect the "Year" dimension ?

It only happens in Cross table, when load a year within the normal column it connects well,

I have tried to write like that - Year(Year). its not duplicate the "Year" but the "YaerBudget" become NULL.

Would appreciate help.

Thanks

[Chanty4u]

i think,

comment drop table and give a try?

[kaushiknsolanki]

Hi,

It is because the year field is coming from excel and it is in text format.

Try this.

Load num(Num#(Year)) as Year

From xyx;

Regards,

Kaushik Solanki

[Xabinav]

Thanks,

It's work

[Anonymous]

a:

CrossTable(year,sales)   

LOAD *

FROM

(ooxml, embedded labels, table is Sheet1);

b:

load

region as region1,

num#(year) as year1,

sales as sales1

Resident a;