topic Re: Built in string function in Set Analysis in QlikView

Built in string function in Set Analysis

p_andreev — Fri, 20 Sep 2013 12:18:55 GMT

Hi all,

Is it possible to have something like the following set analysis working?

sum({$< [Month] = "$(=FieldValue('MonthListName',Match(MonthListName,'January','February','March','April','May','June','July','August','September','Octomber','November','December','Total')))"}>} ItrSalesValue)

Re: Built in string function in Set Analysis

swuehl — Fri, 20 Sep 2013 12:31:59 GMT

Maybe, but what do you want to achieve? How do your data look like, and what is your expected result?

For example, if you select in data island MonthListName, you can try

=sum({<Month = MonthListName>} ItrSalesValue)

Re: Built in string function in Set Analysis

p_andreev — Fri, 20 Sep 2013 13:02:59 GMT

I will try to explain.

Here is a piece of my chart.

General SubCategory	MonthListName	SALES per MONTH	SALES TOTAL
BRASS LEVEL 3	January	668 873.15	668 873.15
	February	668 873.15	1 337 746.30
	March	668 873.15	2 006 619.45
	April	668 873.15	2 675 492.60
	May	668 873.15	3 344 365.75
	June	668 873.15	4 013 238.90
	July	668 873.15	4 682 112.05
	August	668 873.15	5 350 985.20
	September	668 873.15	6 019 858.35
	Octomber	668 873.15	6 688 731.50
	November	668 873.15	7 357 604.65
	December	668 873.15	8 026 477.80
	Total	668 873.15	8 695 350.95

"MonthListName" field is an inline list combined with "General SubCategoriey" in my script. This is because I need all 12 months for every General SubCategory plus one row called Total for custom calculations of the totals.

Now I want to obtain monthly values (SALES per MONTH) without including months from the calendar as a dimension,but only by set analysis.

I hope this is clear.

Re: Built in string function in Set Analysis

swuehl — Fri, 20 Sep 2013 13:08:42 GMT

Set analysis won't consider the current dimension value, the set expression is only evaluated once per chart.

Please check

Evaluating "sets" in the context of a dimension

and try maybe the pick / match method mentioned there.

Re: Re: Built in string function in Set Analysis

Brice-SACCUCCI — Fri, 20 Sep 2013 13:30:35 GMT

Hi,

could you simply associate the Month field with the MonthListName field?

Here is a sample app.

Regards,

Brice

Re: Built in string function in Set Analysis

p_andreev — Fri, 20 Sep 2013 14:17:47 GMT

Thank you very much swuehl !

This is very important and helpful material.

Regards,

Re: Built in string function in Set Analysis

p_andreev — Fri, 27 Sep 2013 05:45:49 GMT

Thank you Brice,

I built my solution taking into account your suggestion.

Best Regards,