topic Re: Variable where in QlikView

Variable where

Aldemarprins4 — Tue, 17 Aug 2021 15:20:08 GMT

Hi guys, I have the following problem, I have a where statement, but I want to include it in a variable, the statement is this

Where Date> = '$ (DateC)' and FlagoneFX = 1;

How can I include this statement in a variable?

Thanks

Re: Variable where

Saravanan_Desingh — Wed, 18 Aug 2021 01:07:38 GMT

So DateC is again a Variable here?

Re: Variable where

Aldemarprins4 — Wed, 18 Aug 2021 01:25:20 GMT

Hello, yes DateC is other Variable,

What I want to do is that when, you have a variable X, do the where with the variable DateC and and FlagoneFX = 1, if the variable is different from X then do

where DateC y and FlagoneFX = 1 and Flagbg = 1

Re: Variable where

Arroyo45 — Thu, 19 Aug 2021 07:55:56 GMT

when i use those variable in where clause(sql query) its not giving output and if i hardcode those vaiable values output will come.

liteblue