topic Re: Set analysis question in QlikView

Set analysis question

Fri, 20 Nov 2020 18:02:30 GMT

I have a data model that has data for multiple years. The year is stored in a field called custOutcomeYear. I would like to create a chart that only sum current revenue data for the current year. The current year is in a varialbe called vCurrentYear. Can this be dine using set analysys? If so how??

Thanks in advance.

Re: Set analysis question

Thu, 12 Jul 2012 03:55:45 GMT

sum({<custOutcomeYear={"$(=vCurrentYear)"}>} current_revenue)

Regards,

Kiran Rokkam.

Re: Set analysis question

Thu, 12 Jul 2012 14:30:52 GMT

same purpose, (slightly) less code, less prone for failures (no (,{ and <>)

sum(if(custOutcomeYear=$CurrentYear,current_revenue))

sum(if(custOutcomeYear=$CurrentYear AND day=$today ,current_revenue))

Re: Set analysis question

Thu, 12 Jul 2012 14:50:13 GMT

Hi Alexander / all,

wouldn't the set analysis be a more efficient way of doing this (ie system performance), as it removes the line by line evaluation of the "if" statement?

Please advise,

Kind regards,

Rich

Re: Set analysis question

jonathandienst — Thu, 12 Jul 2012 14:57:32 GMT

Sum(If()) expressions should be used with caution - they perform very poorly (or not at all) on large data sets. Set analysis expressions perform far better.

Regards

Jonathan

Re: Set analysis question

Thu, 12 Jul 2012 20:26:46 GMT

So if I wanted to display only data for the current year, thein I would have to use something like that for each field I wat to display?

Re: Set analysis question

CELAMBARASAN — Thu, 12 Jul 2012 20:30:20 GMT

Use only for year field, if u need to display disregarding the selection of month, day, quarter, week then exclude that fields

sum({<custOutcomeYear={$(=vCurrentYear)}, Month=, Week=, Quarter=, Day=>} current_revenue)

Re: Set analysis question

Fri, 13 Jul 2012 08:32:01 GMT

set analysis is indeed far more performance efficient.

i wanted to provide an example, as joestang was new to set analysis.

so, if your set analysis seems not to be working, try the more simple example to test your parameters.
if they dont work with the "sum(IF)" example, the problem is not in set analysis, but in the parameter.