topic difference between static and dynamic set analysis in QlikView

difference between static and dynamic set analysis

SunilChauhan — Wed, 29 Dec 2010 07:05:49 GMT

Dear all,

what is difference between static and dynamic set analysis.

can any one help me to write syntax in set analysis

regards

Sunil

difference between static and dynamic set analysis

deepakk — Wed, 29 Dec 2010 07:19:40 GMT

Hi,

As per my understanding Static means getting value for a fixed record.

Eg : Sum ( {<Type= {A}>} Sales)

Here I am fixing my Sales Value to Type A.

Dynamic : Here the value will change as per user selection.

Sum ( {<Year={$(=Max(Year)-1)}>} Sales )

In the above example the value of Year will change based on user selection .

Eg :If user selects 2010 then the it will show value of 2009

You will find more examples in help

Re: difference between static and dynamic set analysis

Fri, 24 Feb 2012 15:56:37 GMT

I cannoot figure out whey this wont work. when I used a variable and hard coded -13 into the variable it worked. But when i try to either assign Max([# of Months from Current Month])-13 to the variable or hard code it in as below, it does not work. I can see the value of the variable = -13 via a text box, but it wont work in the formula. What am I missing?

count ({<[# of Months from Current Month]={$(>=Max([# of Months from Current Month])-13)}>} distinct [Order Number])

difference between static and dynamic set analysis

deepakk — Fri, 24 Feb 2012 17:20:12 GMT

hi,

Your syntax is incorrect. Use the below one

count ({<[# of Months from Current Month]={"<=$(=max(([# of Months from Current Month])-13)) "}>} distinct [Order Number])

I think the above code will work fine.

Deepak

difference between static and dynamic set analysis

Fri, 24 Feb 2012 17:35:37 GMT

Thank you! That worked. I just changed the <= to >= and it worked beautifully! Maybe you can help me with one other question. When the user filters to any month or Quarter, i want the chart to maintain the last 12 months regardless. However, when the filter down to one partner, I want the chart to stay 12 months but filter to only that partners data. would putting in [Fiscal Month]=,Fiscal Quarter]=, into set analysis do that trick.

difference between static and dynamic set analysis

deepakk — Fri, 24 Feb 2012 17:37:37 GMT

Yes That should do the trick.. . Logically what ever the field name user will select you need to ignore that.

Deepak