Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
prasad333
New Contributor III

SET Analysis

Hi everyone,

Now a days I am learning different ways to put set analysis.

For example,

=year(AddYears(maxOrderDate,-1)) & ' vs. ' & year(maxOrderDate)  & ' ' & Only({<No={59}>} [$(=vDataLanguage)]) & ' = ' & num(( sum( {<Year={$(=Max(Year))}>} SalesAmount) - sum({<Year={$(=Max(Year)-1)}>} SalesAmount))/sum( {<Year={$(=Max(Year)-1)}>} SalesAmount), '#.#%')

Now, if anyone would be kind enough to put some more real time examples like this into the list with the explanations for the whole writing ( for what purpose anything is used in the line  ). I know it's bit tedious but I wish someone would do that.

Regards,

KHARANSU

3 Replies
Highlighted
YoussefBelloum
Esteemed Contributor

Re: SET Analysis

Hi,

here is a document where you can find a lot of examples !

Set Analysis: syntaxes, examples

Highlighted
prasad333
New Contributor III

Re: SET Analysis

Hi Youssef,

Thank you for replying. I have gone through this but these are some basic notes. I am looking for some more complex analyses. I hope you can make it.

Highlighted
YoussefBelloum
Esteemed Contributor

Re: SET Analysis

Just decribe the analysis you wanna make, attach sample data, I'm sure 100% experts here will find a solution quickly !