topic Variable in a Set Analysis expression in QlikView

Variable in a Set Analysis expression

Mon, 18 Apr 2011 18:22:32 GMT

Hi,

I'd like to use a variable inside a set analysis expression. Is it possible?

I have tried to use this expression, unsuccessfully:

sum({$<Year = {$(=only(Year))}, Month = {"<=SelectedMonth"}>} DaysNumber), where SelectedMonth is a variable.

Thanks

Variable in a Set Analysis expression

IAMDV — Mon, 18 Apr 2011 18:27:57 GMT

sum({$<Year = {$(=only(Year))}, Month = {$(=$(VariableName))}>>} DaysNumber).

Variable in a Set Analysis expression

IAMDV — Mon, 18 Apr 2011 18:29:27 GMT

Hi,

You should always use the $ sign and the brackets to expland the variable. I hope this helps... please post the QV document, if you still have problems.

Variable in a Set Analysis expression

IAMDV — Mon, 18 Apr 2011 18:33:26 GMT

Also please see the below post on variables expansion used as UDF (user defined function). I thought you might be interested...

http://community.qlik.com/forums/t/43601.aspx

Variable in a Set Analysis expression

Tue, 19 Apr 2011 08:21:15 GMT

Hi, thanks.

Is it right also writing sum({$<Year = {$(=only(Year))}, Month <= {$(=$(VariableName))}>>} DaysNumber)?

I have added Month <= ... instead of Month = ...

Thanks

Variable in a Set Analysis expression

sushil353 — Tue, 19 Apr 2011 08:52:58 GMT

yes this will work fine

Variable in a Set Analysis expression

Tue, 19 Apr 2011 11:05:09 GMT

mmhhh, when I add the minor sign ( < ) in the expression editor I can see the text " <= " underlined in red. This is a mistake!

Thanks

Variable in a Set Analysis expression

jonathandienst — Tue, 19 Apr 2011 11:20:45 GMT

This is, I think, the expression you are looking for:

sum({$<Year = {$(=only(Year))}, Month = {"<=$(=$(VariableName))"}>>} DaysNumber)

or (I think the outer dollar expansion may be unnecessary) ...

sum({$<Year = {$(=only(Year))}, Month = {"<=$(VariableName)"}>>} DaysNumber)

Hope that helps
Jonathan

Variable in a Set Analysis expression

IAMDV — Tue, 19 Apr 2011 11:21:32 GMT

Please can you post the QV document with sample data? It will be much easier to identify...