topic Re: Set Analysis in QlikView

Set Analysis

mvaugusto — Thu, 21 Nov 2013 18:29:16 GMT

To sum some values we use the following function: sum( Value )

Example:

sum( TotalSales )

But, what to do if you want just view the sales of 2014 ?

We can use the Set Analysis, then don't need make SQL script.

Using Set Analysis:

sum( {<Year = {'2014'}>} TotalSales)

This will sum the TotalSales of 2014, without othes years

VishalWaghole — Fri, 22 Nov 2013 07:19:37 GMT

Hi Marcus,

What you want Exactly???

er_mohit — Fri, 22 Nov 2013 07:36:14 GMT

Try this

make a variable vMaxYear

=max(Year) //Expression for variable

then on expression side

SUM(Total {<Year={'$(vMaxYear)'}>} Sales)

or this one also

SUM({1} {<Year={'$(vMaxYear)'}>} Sales)

vikasmahajan — Fri, 22 Nov 2013 07:40:15 GMT

Dynamic

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

vikas

mvaugusto — Fri, 22 Nov 2013 11:47:22 GMT

This is just a exemple for begginers.

Thanks.

vikasmahajan — Fri, 22 Nov 2013 12:05:38 GMT

See Dynamic Full .

Vikas

Fri, 13 Jun 2014 09:16:23 GMT

Thanks for this.

I'm trying to understand set analysis and your file is very helpfull.

I still don't make it with my proper file...

I can see your formulas but there is no numbers. For instance sum (...) match, but sum ( {$} ... ) don't.

My question is :

Can my QV version be too old to set analysis? (QV 8.2)