topic Re: Variable in Set Analysis for text replacement in QlikView

Variable in Set Analysis for text replacement

Tue, 05 Feb 2013 16:32:19 GMT

hello All,

I have lot of expressions in my document which have similar pattern in the set analysis, although the measures differ.

='$'&NUM(ROUND(SUM({<name={'Baby Products'}>}sales)),'##,###,###,###')

this and similar expressions where the 'Baby Products' changes as needed.

Question 1: Is there a way I can put the whole expression in variable for reusability and pass the 'Baby Products' or other value as parameter?

Question 2: I tried putting atleast the "name={'Baby Products'}" in a variable and called vSetFilter and use the expression '$'&NUM(ROUND(SUM({<$(=vSetFilter)>}sales)),'##,###,###,###') but it does not work.

Thanks

Raghu

Re: Variable in Set Analysis for text replacement

Tue, 05 Feb 2013 16:41:14 GMT

Attached is a sample QVW incase you need it.

Thanks

Raghu

Re: Variable in Set Analysis for text replacement

Tue, 05 Feb 2013 16:43:08 GMT

Hi,

you can try with:

='$'&NUM(ROUND(SUM({<name={$(vSetFilter)}>}sales)),'##,###,###,###')

where

vSetFilter = 'Baby Products'

Hope it helps

regards

Giampiero

Re: Variable in Set Analysis for text replacement

Tue, 05 Feb 2013 16:51:30 GMT

Hi Giampiero,

That does not solve the problem of reusability much. I am just replacing 'Baby Products' with $(vSetFilter).

What I wish to do it to make the whole expression as a variable, and then maybe pass another variable like vSetFilter = 'Baby Products' or vSetFilter="name={'Baby Products'}" as a parameter.

Not sure if I am able to explain correctly, but let me know if you have more questions please

Thanks

Raghu

Re: Variable in Set Analysis for text replacement

Tue, 05 Feb 2013 17:23:12 GMT

Hi Raghu,

I understand your problem.

Just a question, how do you want to change the var. value?

Do you want to use an input box or other?

I try to think about your problem.

Regards

Giampiero

Re: Variable in Set Analysis for text replacement

Tue, 05 Feb 2013 17:46:30 GMT

Hi Giampiero,

The way I want to use this is:

Whenver I need an expression, I can use the expression variable and then pass on or concatenate the setFilter variable into the overall expression to get the correct filtering of my data.

Thanks

raghu

Re: Variable in Set Analysis for text replacement

chematos — Tue, 05 Feb 2013 18:07:02 GMT

Have you tried using quotes??

'$'&NUM(ROUND(SUM({<'$(=vSetFilter)'>}sales)),'##,###,###,###')

'$'&NUM(ROUND(SUM({<"$(=vSetFilter)">}sales)),'##,###,###,###')

Re: Variable in Set Analysis for text replacement

Tue, 05 Feb 2013 18:18:31 GMT

This does not work. Incorrect Syntax error.

You can try it in the test QVW I attached above.

Thanks

Raghu

Re: Variable in Set Analysis for text replacement

Wed, 06 Feb 2013 08:47:44 GMT

Hi Raghu,

see attach file.

See the variables.

Hope it helps

Regards

Giampiero