10 Replies Latest reply: Jun 10, 2015 1:05 AM by Brijesh Maurya

# Writing set analysis in Qlikview

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

• ###### newbie question: Writing expressions in Qlikview

Hi Shumailih,

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!

• ###### newbie question: Writing expressions in Qlikview

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.

• ###### Re: newbie question: Writing expressions in Qlikview

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

• ###### Re: newbie question: Writing expressions in Qlikview

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

• ###### newbie question: Writing expressions in Qlikview

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.