Writing set analysis in Qlikview

[Anonymous]

can some one please post a couple of set analysis examples?

[shumailh]

http://community.qlik.com/thread/31007

http://community.qlik.com/docs/DOC-1794

http://community.qlik.com/qlikviews/1000

http://community.qlik.com/docs/DOC-1986

[Anonymous]

Hi Shumailih,

Thanks for your reply!!!

I've allready studied the links you send me execpt the refference manual.

Most of these links focus on creating charts, tabels and selecting/ creating fields. I'm allready familiar with that. Now I would like to focus on how to create (advanced) expressions?

such as these ones below:

= Only({<No={59}>} [$(=vDataLanguage)])

== Only({<No={30}>} [$(=vDataLanguage)]) & ' = ' & Num(Sum (MarginAmount)/Sum (SalesAmount), '#,##0.0%')

Hope you can help!

Thanks in advance

[#4]

Hi aboumejjane, try doing a search on "Set Analysis" - the reference manual does talk about it, but there are many sites that have more examples / explenations on it. I find it very fast and useful with complicated calculations.

[shumailh · Accepted solution]

you are talking about functions, set analysis and work with variables.

= Only({<No={59}>} [$(=vDataLanguage)])

try to explore all these topics from help and forum. eg:

Set Analysis:
sum( {$} Sales ) 
returns sales for the current selection, i.e. the same as sum(Sales).
sum( {$1} Sales ) 
returns sales for the previous selection.
sum( {$_2} Sales ) 
returns sales for the 2nd next selection, i.e. two steps forward. Only relevant if you just made two Back operations. 
sum( {1} Sales ) 
returns total sales within the application, disregarding the selection but not the dimension. If used in a chart with e.g. Products as dimension, each product will get a different value. 
sum( {1} Total Sales ) 
returns total sales within the application, disregarding both selection and dimension. I.e. the same as sum(All Sales).
sum( {BM01} Sales )
returns sales for the bookmark BM01.
sum( {MyBookMark} Sales )
returns sales for the bookmark MyBookMark.
sum({Server\BM01} Sales)
returns the sales for the server bookmark BM01.
sum({Document\MyBookmark}Sales)
returns the sales for the document bookmark MyBookmark.

Cheers

Shumail

[Anonymous]

Hi Shumail,

Thanks for your mail. I was wondering wether you teach me how work with fuctions, expressions and set analysis. Maybe we can setup a skype or msn session.

Other wise send me a private email to c.declaration@gmail.com to discuss the above if you want to.

Thanks!

aissam

[shumailh]

you can contact me on shumailh@gmail.com

[#8]

Hi,

To answer all these questions, there is a book available! - not endorsed, authored or supported by QlikTech -

The authors also faced similar challenges when they started with QlikView, and would like to now share this (very practical) experience with other QlikView users.

For more info, check: http://www.qvapps.com/en/ebooks/hello-qlikview-a-beginners-guide-to-qlikview.html

Enjoy!

[Anonymous]

Thanks a lot!! What a coincidence :D. I found that same book yesterday Cheers!

[#10]

hi ,

the link that http://www.qvapps.com/en/ebooks/hello-qlikview-a-beginners-guide-to-qlikview.html ... that ur

giving for Book... its not showing any thing.. it showing web page not found.. Do u have any other link..

either PDF for this Book. so can u Share here...