Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis

Hi,

Please find attached the qvf file.

i want to calculate the total sum with max(fmonthCD) and metrickeyid(1).

thanks

sunindia‌@

3 Replies
Anonymous
Not applicable
Author

mey be this?

=sum({<MetricKeyID={'1'}, fmonthCD={'$(=max(fmonthCD)'}>} Sales)

deepakqlikview_123
Specialist
Specialist

Try

=sum({<MetricKeyID={'1'}, fmonthCD={'$(=max(fmonthCD)'}>} Sales)

reddy-s
Master II
Master II

Hi Prashanth,

Try this:

=sum({<MetricKeyID={'1'}, fmonthCD={'=$(=max(fmonthCD)'}>} Sales)