Qlik Community

Third-Party Qlik Jobs

Area for people to learn more about current Qlik related job postings.

Not applicable

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?

thanks in advance

1 Solution

Accepted Solutions
Not applicable

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

7 Replies
demoustier
Contributor

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

Employee
Employee

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.

Not applicable

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

Not applicable

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

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

Not applicable

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.

neetha_p
Honored Contributor

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

giakoum
Honored Contributor II

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