topic IF statements in QlikView

IF statements

Tue, 20 Mar 2012 10:29:27 GMT

Hi there...

Im new to this

does anyone know why this will not work as an IF statement in Set Analysis

= IF(

Thanks

({<TheMonth = {'Feb 2012'}>})= "Feb 2012", 0, 1)

Im trying to return the value of 0 if this is equals to "Feb 2012"

CELAMBARASAN — Tue, 20 Mar 2012 10:38:29 GMT

Hi,

You cannot use Set analysis as if then.

Sum({<TheMonth = {'Feb 2012'}>} Sales) it returns Feb 2012 sales its like applying a filter internally.

Celambarasan

Tue, 20 Mar 2012 10:44:13 GMT

hi,

use it simply as:

if(TheMonth='Feb 2012',0,1)...u cannot use set analysis with if statements

Tue, 20 Mar 2012 11:47:30 GMT

Superb, thanks..

I worked this out.. to sum up the results from the last two months ..)

= SUM(

IF(

IF(MonthName(AddMonths(Today(), -2)) = TheMonth, MonthName(AddMonths(Today(), -2)), MonthName(Today()))

, 1, 0)

If i wanted to filter the above also with: StatusCategoryCode = {"AT"}

"as used in set analysis in a previous example", has anyone got any ideas, thanks

CELAMBARASAN — Tue, 20 Mar 2012 12:12:30 GMT

Hi,

Could you tell what your trying to achieve count of something?

Count({<TheMonth = {">=$(MonthName(Today(), -2))"},StatusCategoryCode = {"AT"}>} UniqueFieldName)

Celambarasan

Wed, 21 Mar 2012 04:53:40 GMT

you can define a variable (say vMonth) as:

sum({$<Month={$(vMonth)}, year={'2011'}, StatusCategoryCode={'AT'}>}Sales)