Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Xabinav
Creator
Creator

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

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")

Capture cross.PNG

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

Capture sense.PNG

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

4 Replies
Chanty4u
MVP
MVP

i think,

comment drop table and give a try?

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Xabinav
Creator
Creator
Author

Thanks,

It's work

Anonymous
Not applicable

Capture.PNG

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;