topic Re: Problem with "Year" dimension after cross table in Qlik Sense in QlikView

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

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

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 — Tue, 08 Aug 2017 09:18:13 GMT

i think,

comment drop table and give a try?

kaushiknsolanki — Tue, 08 Aug 2017 09:19:24 GMT

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 — Tue, 08 Aug 2017 09:28:57 GMT

Thanks,

It's work

Anonymous — Tue, 08 Aug 2017 09:56:32 GMT

CrossTable(year,sales)

LOAD *

FROM

(ooxml, embedded labels, table is Sheet1);

load

region as region1,

num#(year) as year1,

sales as sales1

Resident a;