topic Re: Sat Analysis Depth in QlikView

Sat Analysis Depth

Tue, 29 Oct 2013 16:39:26 GMT

Hello,

How deep can sets be nested. I have an expression in a chart. I have the year, the months and the type.

=sum({year={$(=[vYearTwo]},Month={"*"},type=P(worktype)>}Amount)

Re: Sat Analysis Depth

Clever_Anjos — Tue, 29 Oct 2013 16:43:43 GMT

How many levels or how many modifiers?

You can have how many modifiers you want.

About level´s, the documentation is not specific, but I think you shouldn´t go beyond a 2nd level

Re: Sat Analysis Depth

Tue, 29 Oct 2013 16:58:43 GMT

I need the year to be stagnant. I need all months out of the year. I need the worktype to change with selection and I would like to add a business unit that changes with selection also.

for example: show me everything from 2012 where the work type is project and the business unit is manufacturing.

Re: Sat Analysis Depth

Clever_Anjos — Tue, 29 Oct 2013 17:08:27 GMT

Fields that must follow to the selecion does not need to be into your Set Analyis. Try this (with project and the business as listboxes)

=sum({year={$(=[vYearTwo]},Month=>}Amount)

Re: Sat Analysis Depth

Tue, 29 Oct 2013 17:16:31 GMT

I am unable to do that. I have year selection, month selection., business unit selection and worktype selection. This is actullay on expression in a chart. The columns that I am concerned with count(this is the line numbers in the chart), yeartwo(in this case 2011), yearone(2012),currnetYTD,Aggraget Total, and percent. 2011 and 2012 need to be the whole year for the worktype and the business unit. The user is able to select year, month, worktype and business unit.

How can I add the business unit to my current set analysis?

Re: Sat Analysis Depth

Clever_Anjos — Tue, 29 Oct 2013 17:25:14 GMT

you can add how many modifiers you want, separated by ","

sum({<field1={},field2{},field3={},....>} value)

Re: Sat Analysis Depth

Tue, 29 Oct 2013 17:53:48 GMT

Thank you for the swift replies. Is theree any way to include a variable in a set analysis? I have a treeview of the business units and a variable which holds the current selection.

Re: Sat Analysis Depth

Clever_Anjos — Tue, 29 Oct 2013 18:11:46 GMT

Yes, you can

sum({<field1={"$(=yourvariable)"}>}value)

Re: Sat Analysis Depth

Tue, 29 Oct 2013 19:49:05 GMT

This is the current expression that I have:

=sum({1} amount)

I think that I need to add the field treeview instead of the variable since the variable holds the name. I am not entirely sure about this.

How would I insert the treeview field into this expression since the variable did not work?

Thanks,

Frank

Re: Sat Analysis Depth

Clever_Anjos — Tue, 29 Oct 2013 20:01:49 GMT

Into =sum({1} amount) {1} instructs QlikView to sum all amount disregarding any selections. Is that what you want?

Re: Sat Analysis Depth

Wed, 30 Oct 2013 11:00:32 GMT

I am having trouble pasting my complete expression into this window.

I am not sure how to delineate the greater than/less than signs.

There shoud be approximately 70 characters in the following expression:

=sum({1<year={$(={vYearTwo}),month={"*"},worktype=P(worktype)>} amount)

Re: Re: Sat Analysis Depth

Wed, 30 Oct 2013 11:14:53 GMT

Just in case the expression did not format correctly I have atached this file with my expression

Re: Sat Analysis Depth

Clever_Anjos — Wed, 30 Oct 2013 11:25:39 GMT

Add " around your variable

=sum({1<year = {"$(=[vYearTwo])"}, month={"*"},worktype=P(worktype)>} amount)

Re: Sat Analysis Depth

Wed, 30 Oct 2013 11:41:02 GMT

Why shuold he use " ?

Why not ' ?

" is when you need it as a searchstring

' is when outcome is of type string

Im guessing his vYearTwo is a string?

Re: Sat Analysis Depth

Wed, 30 Oct 2013 11:41:03 GMT

Now that you have seen my expression, how do I add a field from my TreeView (businessunit) current selection to this expression.

Re: Sat Analysis Depth

Clever_Anjos — Wed, 30 Oct 2013 13:22:13 GMT

sum({1<year = {"$(=[vYearTwo])"}, month={"*"},worktype=P(worktype),businessunit={"something"}>} amount)

Re: Sat Analysis Depth

Wed, 30 Oct 2013 14:17:02 GMT

There are many docs on Set Analysis. I have published one doc several weeks ago that will answer to your current or folwing questions:

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

Fabrice