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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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