Calculated Field Usage in Charts

[Uma7]

Hi,

i have the fields year,month,sales,region,success,failure,failed%,total where in i made a calculated field year-month for analysis purpose.

But i am not able to use the calculted field in chart.Even if i use the values doesn't appear in the chart.

can anybody help me resolve this?

Thanks in advance!

[BrunPierre]

How is the year-month derived?

[Uma7]

i concatenated the year month columns loaded from data in qlik data manager 

[BrunPierre]

Could you post a sample of the dataset?

[Uma7]

Asia , nz90,2022,03,50,50,0.50%,2022-03

Europe,in90,2023,07,40,60,0.40%,2023

West Asia,An12,2022,09,30,70,0.70%,2022-09

this is how the data looks 

[BrunPierre]

Date(MakeDate(Year,Month,1),'YYYY-MMM') as YearMonth,

[Uma7]

where should i add the expression given by you ?

[BrunPierre · Accepted solution]

Within your load statement.

LOAD Sales,
Region,
Date(MakeDate(Year,Month,1),'YYYY-MMM') as YearMonth,
...
FROM SourceTable;

[Uma7]

thanks will let you know the results