7 Replies Latest reply: Feb 5, 2014 8:37 AM by ioannis giakoumakis

# hi please tell me what is set analysis? how can i write expressions?

hi please tell me what is set analysis? how can i write expressions?

• ###### Re: hi please tell me what is set analysis? how can i write expressions?

You should buy a book about QlikView. QlikView 11 for Developers is an excelent start.

Try reading the blogs here at community too.

• ###### Re: hi please tell me what is set analysis? how can i write expressions?

Hi,

Search also for specific documents. You will perhaps find one I have written few weeks ago:

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

Fabrice

• ###### Re: hi please tell me what is set analysis? how can i write expressions?

thanks ............................bro

• ###### Re: hi please tell me what is set analysis? how can i write expressions?

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.

• ###### Re: hi please tell me what is set analysis? how can i write expressions?

Check this beautiful post for set analysis Romancing with Set Analysis even beginner can understand easily

• ###### Re: hi please tell me what is set analysis? how can i write expressions?

please manoj kumar move this discussion to the correct group. this is the jobs group