topic Dynamic measure to avoid if-statements in QlikView

Dynamic measure to avoid if-statements

Mon, 13 Oct 2014 17:16:37 GMT

I have a nested if-statement:

if([Category]='Events',[Events],

if([Category]='Delegates',[Delegates],

[Value]))

Is there a qlikview function to dynamically point to a measure field?

I have seen examples where you can dynamically point to a field based on a variable, however based on the row content I want to select the specific measure field.

Re: Dynamic measure to avoid if-statements

jerem1234 — Mon, 13 Oct 2014 17:46:01 GMT

You can use match() and pick() like:

pick(match(Category, 'Events', 'Delegates', 'Value'), Events, Delegates, Value)

Or if you want if it doesnt match to anything, then use the Value field:

pick(match(Category, 'Events', 'Delegates')+1, Value, Events, Delegates)

Hope this helps!

Re: Dynamic measure to avoid if-statements

Mon, 13 Oct 2014 18:33:22 GMT

Thanks, that makes the expression look better and I could store a number in the row to avoid the match function.

However, I was looking for something like =sum(Field(SourceField)) where SourceField is a field in the row and based on the value in that field, QV will use the correct measure.

E.g. if SourceField has the value Events, it will translate Field(SourceField) into Events, returning =sum(Events)

Re: Dynamic measure to avoid if-statements

jerem1234 — Mon, 13 Oct 2014 18:52:55 GMT

Unfortunately, the only way I have found is using that match(pick()) combo for tables. If you were making selections on the field SourceField and wanted to get the value for the Field selected, you can do something like:

sum($(=SourceField))

However, like I said before, that won't work when referencing values inside the table since $() won't reference whats in the table.

Hope this helps!

Re: Dynamic measure to avoid if-statements

Mon, 13 Oct 2014 19:14:47 GMT

Thanks for your reply, will use the pick / match function.