Expression update issues in Qlik Sense - QDF framework

pawwy1415 — Tue, 24 Oct 2017 17:02:36 GMT

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.

topic Expression update issues in Qlik Sense - QDF framework in QlikView

Expression update issues in Qlik Sense - QDF framework