Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
tinkerz1
Creator II
Creator II

Alternate states and Max on selection

Hi,

I am trying to combine 2 formulas, I would like to transfer the selections from 'Master Month Date' to MonthLogged_Open_Balance but on the MAX date.

I have written both but can not see how to transfer the selection into an alt state and then perform a max lookup

How can I transfer the below formula into the bottom formula?

MonthLogged_Open_Balance={"$(=DATE(MAX(MonthLogged_Open_Balance),'DD/MM/YYYY'))"}

Count(distinct {
[Base Selection]<[ID]={2},[MonthLogged_Open_Balance]=$::[Master Month Date],[BusinessArea_Open_Balance]=[Base Selection]::BusinessArea,TPACompany_Open_Balance=[Base Selection]::TPACompany,Table={'Pipeline'}>} %KEY_CaseIDR5_Open_Balance)

2 Replies
Gysbert_Wassenaar

It's not clear to me what you want. This perhaps? MonthLogged_Open_Balance={"$(=DATE(MAX({$}[Master Month Date]),'DD/MM/YYYY'))"}


talk is cheap, supply exceeds demand
tinkerz1
Creator II
Creator II
Author

Hi,

MonthLogged_Open_Balance is in a data island on a different Alternate State, I would like to link the Master Month field from the default state to it.

And then only use the max month in Master Month Date.