Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis expression

Hello,

I need explanation for how the below set analysis is calculated and whats the difference in using max and onyl function:

sum([product value])/exchangerate)-(sum({$<year={$(=only([year])-1)}, Month={$(=only([Month]))}>)[product value]/exchangerate)))

Thanks

2 Replies
PrashantSangle

Hi,

Can you post your working expression?

sum([product value])/exchangerate)-(sum({$<year={$(=only([year])-1)}, Month={$(=only([Month]))}>)[product value]/exchangerate)))

This expression have lots of mistake like bracket closing,set analysis closing

Check it

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Not applicable
Author

well i found it on the web somewhere and just wanted to understand it

of how to define modifier and identifier , and why and where all'=' is used