topic Re: How TO pass Dimension from Chart to Function Call Expression in QlikView

How TO pass Dimension from Chart to Function Call Expression

Tue, 26 Feb 2013 20:41:04 GMT

I have an expression that takes a paramater as a value

In one of my charts the values in one of the dimensions are the names I would like to pass to my function. How Would you accomplish this?

$(FunctionName(PassDimension))??

Re: How TO pass Dimension from Chart to Function Call Expression

Tue, 26 Feb 2013 21:20:00 GMT

Can you be more specific? Do you have an example file of what you are trying to accomplish?

Re: How TO pass Dimension from Chart to Function Call Expression

Tue, 26 Feb 2013 21:23:21 GMT

Simple Example I created a function not the following the one i have is very long

v_Vk is Variable

v_Vk is defined as follows

Sum({<X={$1}>}Value)

When Calling the function $(v_Vk(DimensionValue))

I want the DimensionValue to be the Charts Dimension value so I do no have to hard code through each Value thats needed to calculate

Re: How TO pass Dimension from Chart to Function Call Expression

Tue, 26 Feb 2013 22:06:01 GMT

Try something like

$(variable_name($(=field_name))

where variable_name is the name of your parameterized variable and field_name is the name of field containing the values to pass.

However, if you want a chart with user selected dimensions then your method of passing a value to a set analysis will not work (it will filter on the value, not have different dimension). To have user selected dimensions, use

$(=field_name)

in the calculated dimensioni in the chart where field_name contains the list of field names for the user to select.

Re: How TO pass Dimension from Chart to Function Call Expression

Tue, 26 Feb 2013 22:10:35 GMT

This is not getting resolved.

I have a Field_Name dragged into my chart dimension and when i put this into the function it does not get resolved with the dimension in ther pivot table

Re: How TO pass Dimension from Chart to Function Call Expression

Tue, 26 Feb 2013 22:26:04 GMT

Why do you want the dimension value in the expression? The expression are calculated for each dimension value so there usually is no need to know the dimension value. If your chart has field_name as the dimension, the expressions will be calculated for every value in dimension.

Re: How TO pass Dimension from Chart to Function Call Expression

Tue, 26 Feb 2013 22:30:19 GMT

Unfortunatleyt Qlikview has no real way of calculating complex calculations and my equation is now working for PErcent rank for calculating returns over time through geometric linking.

qlikview doesnt have this capability and lacks alot of calculations and abilities and you can break its mold in minutes. I would of loved to not have to use this method of paramater but now I have no choce and need it. And the support that Qlikview offers in the past 5 months (Questions answered - 0)

This is the only thing i have left to finish

Re: How TO pass Dimension from Chart to Function Call Expression

Tue, 26 Feb 2013 23:01:28 GMT

Anyone Answer?

Re: How TO pass Dimension from Chart to Function Call Expression

rwunderlich — Wed, 27 Feb 2013 13:31:25 GMT

There should be no problem passing the Dimension value to a function. For example,

$(vFunction(DimField))

will pass the value of DimField to the variable function. However, based on your earlier post, it looks like you are trying to use the passed value in a Set expression.

Sum({<X={$1}>}Value)

Set expressions can't be modified on a row by row basis in this way. The Set is selected for the whole chart.

I'm guessing that what you are trying to accomplish is to widen the dimension for your calculation. That is, for a chart row with Dim1, Dim2, Dim3, you want to sum(Value) for Dim1. The correct way to do that is with an aggr() function.

=aggr(Sum(Value), Dim1))

Did I get it right? If not could you post some more details on the chart dims and specifically what you compute?

-Rob

http://robwunderlich.com

Re: How TO pass Dimension from Chart to Function Call Expression

Wed, 27 Feb 2013 13:49:11 GMT

I am using aggr the problem is without using the set analysis in the each item the value is incorrect

Solving for the following to be the same with and without the Set analysis

FirstSortedValue({<Inv={"=sum(aggr(exp(sum({<GroupName={$1}>} log(1+Pricing)))-1,Inv, GroupName)) <
$(=(exp(SUM(aggr(log(1+SUM({<GroupName={$1}>}Value1)/SUM({<GroupName={$1}>}Value2))
, GroupName, BusinessDate)))-1))
"}>}
(aggr(exp(sum({<GroupName={$1}>}log(1+Pricing)))-1,Inv, GroupName))
,-(aggr(exp( sum({<GroupName={$1}>} log(1+Pricing)))-1,Inv, GroupName))
)

Re: How TO pass Dimension from Chart to Function Call Expression

rwunderlich — Wed, 27 Feb 2013 14:14:13 GMT

The way to do row by row conditional is with if() instead of Set Analysis. For example

sum(if(GroupName=$1, Value))

Might that work for you?

-Rob

Re: How TO pass Dimension from Chart to Function Call Expression

Wed, 27 Feb 2013 14:16:46 GMT

Thats what Im trying to avoid

Re: How TO pass Dimension from Chart to Function Call Expression

sabreyals — Mon, 09 Sep 2019 20:48:34 GMT

I have a similar issue and i have posted it in the New to Qliksense forum where I ideally want to pass the dimension value to the set analysis part of the expression like this

Sum({<Vintage={'$(=$(vMaxVinNum(Mkt_Name)))'}>}Measure)

where vMaxVinNum=max({<Market={$1}>}VintageNumber)

I understand that the set analysis is calculated just once per chart but aggr doesn't work either.

because each market has a different value for max(Vintage) but the set analysis sees only one value.

Any ideas?

My Post:

https://community.qlik.com/t5/New-to-Qlik-Sense/How-to-pass-dimension-value-to-a-measure-in-set-analysis-within/td-p/1621727