topic Calculated Field Usage in Charts in Data Movement & Streaming

Calculated Field Usage in Charts

Uma7 — Wed, 19 Mar 2025 23:04:08 GMT

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 — Mon, 29 May 2023 07:23:55 GMT

How is the year-month derived?

Uma7 — Mon, 29 May 2023 07:26:53 GMT

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

BrunPierre — Mon, 29 May 2023 07:57:23 GMT

Could you post a sample of the dataset?

Uma7 — Mon, 29 May 2023 08:22:48 GMT

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 — Mon, 29 May 2023 08:37:19 GMT

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

Uma7 — Mon, 29 May 2023 08:39:41 GMT

where should i add the expression given by you ?

BrunPierre — Mon, 29 May 2023 09:04:17 GMT

Within your load statement.

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

Uma7 — Mon, 29 May 2023 09:06:02 GMT

thanks will let you know the results