topic Variables in Set Analysis in QlikView

Variables in Set Analysis

poluvidyasagar — Thu, 30 May 2019 14:37:43 GMT

Hi,

I am trying to use variables in set analysis.

Data:

Location *

DS_V1FIN_P

DS_ENGINE_P

DROP_CAC

DROP_SHIP

DS_V1FINISH

2D3506163

1D6506911

DS_ENGINE

Variable Defined:

vLoc= if(wildmatch([Location *],'2*','1*','B*','DS*') and Right([Location *],2)<>'WP' and Right([Location *],2)<>'_P',[Location *])

Text Object Expression:

=Count({<[Location *]={'$=($(vLoc))'}>}[Location *])

This expression does not work.

Can some one please explain the syntax for variables in set expression? How to fix the expression above?

Please find attached qvw file.

Thanks,

Vidya

Re: Variables in Set Analysis

sunny_talwar — Thu, 30 May 2019 19:04:15 GMT

Try this

=Count({<[Location *] = {"=WildMatch([Location *], '2*', '1*', 'B*', 'DS*') and Right([Location *], 2) <> 'WP' and Right([Location *], 2) <> '_P'"}>}[Location *])

Re: Variables in Set Analysis

poluvidyasagar — Thu, 30 May 2019 20:22:41 GMT

Hi Sunny,

It works perfect. But why does it not work using variable in side set expression.

Thanks,
Vidya

Re: Variables in Set Analysis

sunny_talwar — Fri, 31 May 2019 00:57:02 GMT

Because I don't think what you were using in set analysis was the right way to do it....

Re: Variables in Set Analysis

poluvidyasagar — Fri, 31 May 2019 13:34:21 GMT

What is the right syntax for using variables in set expression?

Re: Variables in Set Analysis

sunny_talwar — Fri, 31 May 2019 13:59:34 GMT

It depends on various different things... there is no one holy grail I can provide you... but in general you can start here The Magic of Variables