topic Re: Variables and if statements in QlikView

Variables and if statements

caseyjohnson — Fri, 11 Nov 2016 01:26:03 GMT

Having difficulty with using variables in IF statements (being used as measures). Trying to use these expressions in a straight table. The variables themselves work fine in the tables, but trying to use them in conjunction with the IF statements are not working? Can't figure out why they won't work ... usually get back (zero) or a blank field. Any help is appreciated.

Example:

vExample = Sum(sales)

if ( parts_age <= 90, $(vExample) ) ----- Does not seem to work?

if ( parts_age = 90, $(vExample) ) ----- Does seem to work ???

Is there an issue with using relational operators in IF statements????

Re: Variables and if statements

Chanty4u — Fri, 11 Nov 2016 04:33:35 GMT

it works i think.

u can try below simple example

try: if ($(vStartYear)< 2012,'YES','No')

Re: Variables and if statements

Fri, 11 Nov 2016 05:20:31 GMT

First check whether your variables getting data or not then use it

Re: Variables and if statements

vardhancse — Fri, 11 Nov 2016 05:58:09 GMT

Hi,

while creating new variable make sure '=' was removed for the Variable value.

= Sum(sales)

Re: Variables and if statements

jonathandienst — Fri, 11 Nov 2016 06:38:44 GMT

There's nothing wrong with either statement. To get more useful help and not just guesswork, I suggest that you upload a small sample qvw to illustrate the problem.

Preparing examples for Upload - Reduction and Data Scrambling