Hi,
Please note this is in Qlik Sense
We are maintaining our expressions in Excel file and using QDF Framework.
Below three expressions are used in Qlik Sense. -- expression values are coming under below columns
A B C D E F G H
After uploading expression, I could see below expressions are populating in QlikSense.. which I can see through variable editor.
It's working fine when I am using as ($(vKPIMetrics.Red)
I have used vKP.Metric.Red directly but it's not working. It's showing '- ' in expression. I want to use it's directly as I want to put additional condition in this expression and test it before make changes in excel. ( I want to add this confition =Pick(Match([Metric Group],'Culture & Behaviours'),[Metric Group]) ))
Sum(if(Aggr(Max({$<MonthYear ={'$(=$(vG.CurrentPeriod))'},[Metric Group]-={'-'"}, [Metric]-={"'-'"},Group-={"''-"},[Sub Group]-={"'-'"}>}[RAG Ind]),[Metric Group], Metric)=2,1,0)))
Could you please help what I am doing wrong and if I make changes directly in excel under which column should I add condition? Also, I am not sure how it's uploaded in Qlik Sense, In Qlik view we used to use Peek function etc to upload it.