topic Re: Set analysis on chart level in QlikView

Set analysis on chart level

pennetzdorfer — Wed, 22 Aug 2012 13:31:32 GMT

Hey,

Is there a way to define set analysis on chart level?

I've got a straight table containing several expressions, which should be calculated irrespective of the selection in listbox "Country". e.g.

sum({ < Country = > } Sales)

It would be handy to define set analysis once (e.g. in General tab) rather than putting it into each expression separately.

Thanks for your suggestions!

Re: Set analysis on chart level

Anonymous — Wed, 22 Aug 2012 13:40:30 GMT

Hello Florian,

Why don't you create a variable with the 'set analysis' condition text.

Then you need to place your variable (e.g. $(vSetCondition)) inside of each chart's expression.

For example:

Sum({< $(vSetCondition) >} SalesAmount)

Kind regards,

Janusz

Re: Set analysis on chart level

pennetzdorfer — Wed, 22 Aug 2012 14:26:47 GMT

Thanks Janusz, but according to your suggestion I still have to adapt each expression separately.

My idea was to have expressions without any set analysis and "source it out" to the chart level instead.

That would be the most efficient way in my opinion.

Re: Set analysis on chart level

Anonymous — Wed, 22 Aug 2012 14:38:49 GMT

Hi Florian,

You can still achieve that by creating a variable for each expression seperately.

1. Define variable

vExpression1 - sum(SalesAmount)

2. Make a call for the variable's value as a chart's expression

=$(vExpression1)

Give it a try and let me know if this is what you had in mind.

Kind regards,

Janusz

Re: Set analysis on chart level

pennetzdorfer — Thu, 23 Aug 2012 07:43:22 GMT

Thanks Janusz,

unfortunately that's not really what I've in mind.

I would like to have expressions without set analysis and without variables. They should just contain some basic aggregation formulas (sum, count etc).

Having that "default chart" I would like to use it in different cases. If there was a possibility to define set analysis on chart level that would be the most convenient way. I would just make a copy of the chart and change the set analysis to my requirements (thus, no need to change variables in expressions ...)

Re: Set analysis on chart level

Thu, 23 Aug 2012 08:02:15 GMT

You would like to essentially make a dynamic expression on the fly, you would need to do this with a large micture of variables and using functions getfieldselection etc. It is possible but takes a while to put together, it is however not overly efficient in terms of calculation time as the server has to constantly calculate and it makes caching difficult. I would suggest avoiding it if possible if it is not possible I will try to put together an exaple when I get a chance.

Re: Set analysis on chart level

pennetzdorfer — Fri, 24 Aug 2012 10:05:06 GMT

Felim,

my goal was to simplify things. So, as there obviously is no "simple" solution to this, it won't make sense to go for a complex workaround

Thanks for you help though!