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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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