topic newbie question: Writing expressions in Qlikview in QlikView

Writing set analysis in Qlikview

Anonymous — Thu, 14 Jul 2011 09:22:41 GMT

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

newbie question: Writing expressions in Qlikview

shumailh — Thu, 14 Jul 2011 09:48:48 GMT

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

newbie question: Writing expressions in Qlikview

Anonymous — Thu, 14 Jul 2011 15:35:50 GMT

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

newbie question: Writing expressions in Qlikview

Thu, 14 Jul 2011 23:00:36 GMT

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

shumailh — Sun, 17 Jul 2011 06:04:14 GMT

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

Anonymous — Mon, 18 Jul 2011 09:16:00 GMT

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

Re: newbie question: Writing expressions in Qlikview

shumailh — Mon, 18 Jul 2011 09:27:15 GMT

you can contact me on shumailh@gmail.com

newbie question: Writing expressions in Qlikview

Tue, 06 Sep 2011 20:37:03 GMT

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!

Re: newbie question: Writing expressions in Qlikview

Anonymous — Wed, 07 Sep 2011 06:12:11 GMT

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

Re: newbie question: Writing expressions in Qlikview

Wed, 10 Jun 2015 05:05:43 GMT

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

Re: newbie question: Writing expressions in Qlikview

Wed, 10 Jun 2015 05:06:19 GMT

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