topic Re: Need help removing IF statement in front of Set Analysis in QlikView

Need help removing IF statement in front of Set Analysis

Thu, 26 Feb 2015 22:53:45 GMT

Can someone please help me figure out how to get rid of this IF statement in the beginning of my SET analysis?

This script works fine and returns the correct values:

=if(MonthYear= date($(=max(MonthYear)),'MMM-YYYY'),
    sum({$<
        CheckYear = {$(=Max(CheckYear))},
        PrimaryPositionYN={1},
        EarningsHistoryYN -= {1},
        NonCashYN = {0}
        >}
    [Current Earnings])
)

Any help would be appreciated.

Re: Need help removing IF statement in front of Set Analysis

anbu1984 — Fri, 27 Feb 2015 02:27:46 GMT

Do you want calculate Sum for all MonthYear? Then try this

sum({$<

CheckYear = {$(=Max(CheckYear))},

PrimaryPositionYN={1},

EarningsHistoryYN -= {1},

NonCashYN = {0}

[Current Earnings])

Re: Need help removing IF statement in front of Set Analysis

PrashantSangle — Fri, 27 Feb 2015 04:51:53 GMT

Hi,

It depends what kind dimension you are using, If you are using MonthYear as Dimension also then you have to use that if statement .

If you are not using as dimension then

try

sum({$<

        MonthYear={"$(=date(max(MonthYear),'MMM-YYYY'))"}
        CheckYear = {$(=Max(CheckYear))},
        PrimaryPositionYN={1},
        EarningsHistoryYN -= {1},
         NonCashYN = {0}
>}
[Current Earnings])

Regards