topic Re: Set Analysis with variables does not work in QlikView

Set Analysis with variables does not work

bettina13 — Thu, 02 Jun 2016 05:25:57 GMT

Hello,

let varA and varB be variables and let fieldX, fieldY, fieldZ be fields. Let c be a constant.

The following expressions work:

Sum ($ { < fieldX = {$(varA)} > } fieldY) and

Sum ($ { < fieldX = {"<= c"} > } fieldY).

The following expressions do not work:

Sum ($ { < fieldX = {"<=$(varA)"} > } fieldY) and

Sum ($ { < fieldX = {$(varA)} or fieldZ = {$(varB)}> } fieldY).

Has anyone an idea how to work with two variables in the Expression between < and > or how to work with "<="?

Thanks for your answer.

Bettina

Kushal_Chawda — Thu, 02 Jun 2016 09:09:52 GMT

what is the value in varA, if it is number, below expression should work

Sum ($ { < fieldX = {"<=$(varA)"} > } fieldY)

try this

Sum ($ { < fieldX = {"$(varA)"} ,fieldZ = {"$(varB)"}> } fieldY).

bettina13 — Tue, 07 Jun 2016 06:46:10 GMT

Hi,

thanks for your answer.

The type of varA is date. I tried the same formula with Num (VarA) and had no success.

I also tried an Expression separated by commata without success.

Has anybody another idea?