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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Ravi1
Partner - Contributor II
Partner - Contributor II

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