Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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