Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
NavinReddy
Creator II
Creator II

Formula error

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,

NR

 

2 Replies
NavinReddy
Creator II
Creator II
Author

Any Suggestions please 

Brett_Bleess
Support (Former)
Support (Former)

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.