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

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
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

Labels (1)
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