topic Formula error in QlikView

Formula error

NavinReddy — Mon, 12 Oct 2020 00:21:55 GMT

Hello All,

When i select month in filters the calculated dimension and Expression is not working. I am getting N/A for both below expressions. Kindly someone help me, how can i get the values based on selections.

variable: Date(MonthStart(Date(Date)),'MMM YY') as MonthYear,

Dimension: Num#(Amber_Operator)&''& num(maxstring({<MonthYear={"$(=(date(max(MonthYear),'MMM YY')))"}>} amber_threshold_value)

Expression: Num(MaxString({<MonthYear=,MonthYear={"$(=date(MonthYear,'MMM YY'))"}>}VALUE_QT)

Kindly help me, every where im getting NA or expression and dimensions

Thanks in Advance,

Re: Formula error

NavinReddy — Mon, 12 Oct 2020 06:23:03 GMT

Any Suggestions please

Re: Formula error

Brett_Bleess — Tue, 27 Oct 2020 14:38:02 GMT

You are likely going to need to attach sample QVW file on this one to get further assistance as this is a fairly entailed question and folks likely will need to see the data model of the application as well as the sheet object in question in order to be able to offer up suggestions.

Regards,
Brett