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

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
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