Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Ravi1
Partner
Partner

qlik sense

i have two tables master and fact these tables are linked using s.no values from 1 to 6

I need the sum(amount) for S.no = 4 on selecting S.no= 6

i used "=If([S.No]=6,Sum({<[S.No]={4},Year={"$(=Max(Year)-1)"},MonthNo={"$(=Max(MonthNo))"}>}Amount),0)" 

This didn't work

need help please

0 Replies