topic Re: Variables with parameters in QlikView

Variables with parameters

Fri, 06 Jun 2014 16:53:53 GMT

Hi,

I want to create a table with a variable with parameter. For example, i have the dimension year, and a variable that calculate the sales

of each year vSalesperYear($(variable1)), the thing is that the value of variable1 depends on de dimension year.

Imagine this is a qlikview table with dimension year and expresion $(variable1)

year variable1

2014 1

2015 2

I want to create a table with dimension year and expression vSalesPerYear($(variable1)).

Can anyone help me??

Thanks,

Re: Variables with parameters

Fri, 06 Jun 2014 16:57:02 GMT

What are you trying to accomplish with these variables? You might be able to accomplish your goal without using variables. Can you explain what your end goal is?

Re: Variables with parameters

Fri, 06 Jun 2014 17:04:42 GMT

i use variables only to use the expression i many graphs.

without using variables would be like this

sum({<idDate={"expresion that calculate the id"}>}sales)

but the expression that calculate the id depends on the dimension year, and the table i want to create have year

as a dimension, so i want that the expression that calculate the id, changes with the diferrentes values of year in my table

Re: Variables with parameters

Fri, 06 Jun 2014 17:10:09 GMT

Is there any chance you could share your qvw? It would help in giving you a specific answer.

Re: Variables with parameters

Fri, 06 Jun 2014 17:12:47 GMT

sry, i cant. Confidential information of my company.

Re: Variables with parameters

Fri, 06 Jun 2014 17:14:30 GMT

What is the "expression that calculates the id"?

Re: Variables with parameters

Fri, 06 Jun 2014 17:22:24 GMT

is any expresion for example min(iddate), the important things is that the expression changes with the diferrent values of the dimension

like this

year min(iddate) sum({<idDate={"min(iddate"}>}sales)

2010 1 sum({<idDate={"1"}>}sales) i want the result of this exprresion

2011 3 sum({<idDate={"3"}>}sales)

Re: Variables with parameters

Fri, 06 Jun 2014 18:10:25 GMT

Are you saying you want to dynamically change which expression will calculate the value of a particular variable?

Re: Variables with parameters

Fri, 06 Jun 2014 18:12:14 GMT

So you want this:

sum({<idDate = {min(iddate from a certain year)>}Sales)

Re: Variables with parameters

Fri, 06 Jun 2014 19:30:11 GMT

correct, but i seems that Set Analysis will only get evaluated once for your objects, it does not get evaluated for every single row.

Re: Variables with parameters

Fri, 06 Jun 2014 20:02:11 GMT

you can try sum(if(idDate = min({<Year =>}idDate), Sales))

I'm not sure this is exactly right, but if you want to include a dimension in your calculation I believe you must use an if statement within your expression.

See this post for help as well: Evaluating "sets" in the context of a dimension