Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
aboumejjane
Creator
Creator

Writing set analysis in Qlikview

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

1 Solution

Accepted Solutions
shumailh
Creator III
Creator III

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

View solution in original post

10 Replies
aboumejjane
Creator
Creator
Author

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

Not applicable

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
Creator III
Creator III

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

aboumejjane
Creator
Creator
Author

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
Creator III
Creator III

you can contact me on shumailh@gmail.com

Not applicable

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!

aboumejjane
Creator
Creator
Author

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

Not applicable

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...