topic selecting which dimensions will affect a chart in QlikView

selecting which dimensions will affect a chart

Tue, 12 Jun 2012 13:10:07 GMT

i created a chart thatcalculates EoY forcast for my budget.

the forcast is calculated as actuall expenses YTD, not including current month and to that i add total expenses of last month multiplied by number of month to EoY.

now, i would like that calculation to be effected by all dimension selections available in that page excludind date based dimensions.

i know it has somthing to do with 'sum({<dimension_name>}expression) where i will detail all dimensions that should effect the calculation,

but i cant seem to get it work.

any ideas?

Re: selecting which dimensions will affect a chart

swuehl — Tue, 12 Jun 2012 13:19:50 GMT

If you want your calculation to be effected by all selections in fields except for example date based, you need to clear the selections in these fields, and yes, you could do this like you already stated in your post, for example like:

=sum({<Date=, Month=, Year=>} expression)

Re: selecting which dimensions will affect a chart

jonathandienst — Tue, 12 Jun 2012 13:28:45 GMT

By default, all selections will affect the results of the expression. You can specifically prevent selections from being applied to your expression. For example

Sum({<Category=>} Value)

will ignore selections on the Category field.

If by dimension, you are referring to chart dimensions, then the TOTAL clause will control which chart dimensions affect your expression. For exampe

Sum(TOTAL <Category> Value)

will ignore the Category dimension when calculating the sum (ie will tota all Category values without regard to the dimension)

Hope that helps

Jonathan

Re: selecting which dimensions will affect a chart

Tue, 12 Jun 2012 13:39:01 GMT

thank you swuehl and jonathan.

it working just as i needed it.

now, in some discussions i see that users also add a '$'.

meaning:

=sum({$<Date=, Month=, Year=>} expression)

what is the '$' meant to do?

Re: selecting which dimensions will affect a chart

swuehl — Tue, 12 Jun 2012 13:50:38 GMT

The dollar sign is used as a set identifier here and is representing the records of the current selection.

Please check the Help, set analysis, for more details.

I also found this series of blogs quite useful:

http://iqlik.wordpress.com/2010/09/11/the-magic-of-set-analysis-syntax-and-examples/

Regards,

Stefan

Re: selecting which dimensions will affect a chart

Anonymous — Tue, 12 Jun 2012 15:37:49 GMT

hi ,

you can also read this manual I think is very usefull

http://community.qlik.com/servlet/JiveServlet/previewBody/1867-102-1-1858/QlikLearn-Set-Analysis-Presentation.pdf