Discussion board where members can learn more about Qlik Sense App Development and Usage.
Hi all. I'm trying a new solution for a problem I posted here. I am now trying instead to combine separate tables in the UI, where one of the tables has an incomplete date set.
I want to generate the DesiredUITable below, where across the dimensions of Person and MonthEnd, if there is a corresponding FactMonthEnd I get the Fact value, else I get 0 or null.
My attempt below right is if(FactMonthEnd=MonthEnd,Fact). This generates excess null values on the rows where there is a Fact.
Any suggestions how I can get to the DesiredUITable below? Thanks in advance.