topic Re: variable with comma parameter in QlikView

variable with comma parameter

kristof_j — Tue, 26 Jul 2016 13:29:43 GMT

Hi all

I wanted to use a variable with parameter and use 'total' as parameter. Like this expression

$(eCountDistinct( total ))

So far so good.

When I want to expand the total with 2 parameter like 'total <product_level1, product_level2>' the comma is interpreted as the end of the variable parameter.

The following examples don't work:

$(eCountDistinct( total <product_level1, product_level2> ))
$(eCountDistinct( 'total <product_level1, product_level2>' ))
$(eCountDistinct( "total <product_level1, product_level2>" ))

How can I solve this?

Re: variable with comma parameter

jonathandienst — Tue, 26 Jul 2016 13:35:00 GMT

Did you try enclosing the parameter with quotes?

$(eCountDistinct(' total <product_level1, product_level2> '))

$(eCountDistinct(" total <product_level1, product_level2> "))

Re: variable with comma parameter

kristof_j — Tue, 26 Jul 2016 13:43:27 GMT

I tried that but I didn't work.

Does it work with you?

Re: variable with comma parameter

sunny_talwar — Tue, 26 Jul 2016 13:54:17 GMT

See if this helps:

eCountDistinct

count(DISTINCT $1, $2 customer)

eExpression

$(eCountDistinct($(vParameter)))

vParameter

1) TOTAL <product_level1,>

2) TOTAL <product_level1, product_level2>

Re: variable with comma parameter

Anil_Babu_Samineni — Tue, 26 Jul 2016 13:57:25 GMT

eCountDistinct -- count(DISTINCT $1 customer) -- Here , what you want to achieve

vParameter -- total <product_level1> -- Is that is Garbage error(What is the mean of set expression)

Re: variable with comma parameter

jonathandienst — Tue, 26 Jul 2016 13:59:34 GMT

No, I have never had this problem, so it was just my 2c worth

Re: variable with comma parameter

antoniotiman — Tue, 26 Jul 2016 14:01:14 GMT

Why not

Re: variable with comma parameter

kristof_j — Tue, 26 Jul 2016 14:04:26 GMT

This is a step forward.

But I still experience some difficulties when I want 3 or more parameters in the total.

I wanted to use this method for some expressions that have 5 dynamic parameters in the total.

Re: variable with comma parameter

vinieme12 — Tue, 26 Jul 2016 14:07:28 GMT

see attached

Re: variable with comma parameter

kristof_j — Tue, 26 Jul 2016 14:14:18 GMT

I wanted to use a variable with a parameter so that I can use this for several expressions with different totals.

In this way I have 1 expression to maintain and other expressions that use that one expression with different totals.

I used vParameter just to make it more easy to make changes if you guys wanted 🙂

Your sollution would be plan B.

I thought I could make it more elegant 🙂

Re: variable with comma parameter

santiago_respane — Tue, 26 Jul 2016 14:21:20 GMT

Hi,

for this i don't use variables with parameters. I use concatenation and substitution of variables like this:

eCountDistinct = Count(DISTINCT $(=MyParameterVar) customer)

MyParameterVar = TOTAL <product_level1,product_level2,product_level3>

MyExpression = $(eCountDistinct)

This way it always works and i never have to fight with commas in parameters.

Hope this helps.

Kind regards,

Re: variable with comma parameter

wcilliers — Thu, 22 Sep 2016 11:42:27 GMT

Hi All,

I have a similar problem and was hoping you might help. I am trying to use a variable to pass the parameter back. But by using a GetFieldSelections() in the variable to send back my selections as a parameter.

Please see attached.

Hope you can help.

Thanks in advance,

Wynand. !

Re: variable with comma parameter

sunny_talwar — Fri, 23 Sep 2016 00:53:31 GMT

May be see if attached is what you are looking for.

Best,

Sunny

Re: variable with comma parameter

wcilliers — Fri, 23 Sep 2016 06:26:08 GMT

Perfect, thanks Sunny!

Re: variable with comma parameter

kristof_j — Fri, 23 Sep 2016 14:00:33 GMT

That works if you know how many parameters you want.

I don't know in advance how many I need or how many other colleagues will use.

That's why I wanted to use a comma in one value.

Re: variable with comma parameter

sunny_talwar — Fri, 23 Sep 2016 14:02:40 GMT

Hahahaha may be add upto $500 in advance

Re: variable with comma parameter

kristof_j — Fri, 23 Sep 2016 14:10:47 GMT

Indeed but what do you if you have something like this

sum( $1 $2 $3 $4 customer)

and you want

sum( total<dim1, dim2> { <dim1 = {1}, dim2 = {2}> } customer)

That is my aim 🙂

Maybe I should write all the expressions in full

Re: variable with comma parameter

sunny_talwar — Fri, 23 Sep 2016 14:15:03 GMT

I guess may be do it this way

Storing variables outside of QlikView - The Qlik Fix! The Qlik Fix!

Re: variable with comma parameter

marcus_sommer — Fri, 23 Sep 2016 14:42:59 GMT

In general that's possible - you could replace everything with the parameters but you must be careful how to declare the various parameters and how they are then processed within the variables. If you want to replace nearly everything with multiplen dimensions within totals and set analysis and something more then you will need some efforts to build a stable logic and to find the right syntax for each type.

I think this will be helpful for you: (and read the comments, too)

Variables

Re: nested variable troubles

Comma problem (,) workaround for dollar sign expansion with parameters

- Marcus

Re: variable with comma parameter

Digvijay_Singh — Fri, 23 Sep 2016 15:25:24 GMT

$0 means how many parameters passed to the function. Not sure if that can be used in any sense.

On a lighter note

Everything Should Be Made as Simple as Possible, But Not Simpler - Albert Einstein

Thanks,