Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
pawwy1415
Creator III
Creator III

Expression update issues in Qlik Sense - QDF framework

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

Capture1.PNG

After uploading expression, I could see below expressions are populating in QlikSense.. which I can see through variable editor.

Capture.PNG

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.

0 Replies