Sum skript table and sql varchar change tot date

[kkarlste]

Hi

It's sql table varchar

Hi

It's sql table varchar

This working Sum( {<MonthYear={'$(=MaxString(MonthYear))'}>} QC_EvaluationResult)
but there will be no years and months for the columns
Month year is varchar sql table. How do I change the script to varchar to date.
If after this the formula could sum the values ​​per month

[Aditya_Chitale]

Use one of the expressions in Qlik Sense Script:

1. Date(Date#(Year,'YYYY'),'YYYY') as Year_New
2. num(num#(Year)) as Year_New

in your script to convert varchar Year to date format Year.

Regards,

Aditya

[kkarlste]

Hi


Yes, but it needs to be included in this script

Sum( {<MonthYear={'$(=MaxString(MonthYear))'}>} QC_EvaluationResult)

[Aditya_Chitale]

If your field is in month-Year format, you will have to extract year part from it using script and then  you can use below set expression to show only  max(Year) sum values.

Sum({<Year={"$(=max(Year))"}>}QC_EvaluationResult)

Regards,

Aditya

[kkarlste]

Sorry, but not working.
Sum({<Year={"$(=max(Year))"}>}QC_EvaluationResult)

YearKey is varchar sql database where this calender loading to Sense

And this is model what I Want show this data