topic Re: Parameter in set analysis in QlikView

Parameter in set analysis

Wed, 25 Mar 2015 14:33:42 GMT

Does anyone know how can I put a parameter in Set analysis?

Thanks

Ced

jpenuliar — Wed, 25 Mar 2015 15:54:12 GMT

This might help:

buzzy996 — Wed, 25 Mar 2015 15:58:34 GMT

u can try,

careate a varibale and use tht variable in ur set expression.

and pass value to ur variable through input box/or some other way,that values will pass automatically to ur set analysis expression.

Wed, 25 Mar 2015 16:05:06 GMT

Thanks but it's a video for basic set analysis, and I want an information about a functionality advanced.

Wed, 25 Mar 2015 16:10:09 GMT

Ok I found the good response with an example:

Ced

stigchel — Wed, 25 Mar 2015 16:13:22 GMT

Use dollar sign expansion (see help) in set expression like

Sum({<MyField={'$(=vMyVariable)'}>} Sales)

Realize that this is evaluated once for the whole chart, so not per dimension(row) value

buzzy996 — Wed, 25 Mar 2015 16:14:02 GMT

good,the same example written in above my statements.