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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sum with set analysys not work

Hi all

i want have sum by year and month

i use this espression

=sum({$<AnnoDoc={$(=Max(AE)-2 )},Mesi={<=$(min)}> } ValTot)

wher $(min) is a variabile... but not work..

Thank

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

=sum({$<AnnoDoc={'$(=Max(AE)-2)'},Mesi={'<=$(min)'}> } ValTot)

View solution in original post

5 Replies
MK_QSL
MVP
MVP

=sum({$<AnnoDoc={'$(=Max(AE)-2)'},Mesi={'<=$(min)'}> } ValTot)

Anonymous
Not applicable
Author

Thank for answer Manish , but

espression still ignore Mesi and sum all the month

MK_QSL
MVP
MVP

Can you provide some sample data?

Anonymous
Not applicable
Author

Hi Andrea,

Could you share your $(min) expression?

Thanks!

Anonymous
Not applicable
Author

Thank Manish and all of you , i was type wrong expression

It work perfect.

Thank for help