Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Conditions to Set Analysis

Hello Everyone,

I want to learn, how we can change the following if...else expression to a set analysis syntax.

sum(if(STAGE='Pending' AND CREATED_DATE<= Today() AND  REVENUE_RECOGNITION_FLAG<>'No' AND OPP_REG_ARCHIVE<>'False' AND IS_PART_ACTIVE=1 AND DESIGN_REG_STATUS<>'Rejected', TOTAL_VALUE))

I would be grateful if someone could please answer it please,

Thanking you beforehand,

Bikash

2 Replies
erich_shiino
Honored Contributor

Conditions to Set Analysis

Try this:

sum( {< STAGE={Pending}, CREATED_DATE= {"<= $( =Today())"},  REVENUE_RECOGNITION_FLAG-={No},  OPP_REG_ARCHIVE-={'False'} ,  IS_PART_ACTIVE={1}, DESIGN_REG_STATUS-={ Rejected} > }  TOTAL_VALUE)

I guess the only trick part may be the CREATED_DATE. If it doesn't work, you should created a numeric field on the script to achieve this

The syntax would be something like:

LOAD

CREATED_DATE,

NUM(CREATED_DATE) AS NCREATED_DATE

...  [ THE REST OF YOUR LOAD SCRIPT]

Then, on set analysis it would be:

sum( {< STAGE={Pending}, CREATED_DATE= {"<= $(=num(Today()))"},  REVENUE_RECOGNITION_FLAG-={No},  OPP_REG_ARCHIVE-={'False'} ,  IS_PART_ACTIVE={1}, DESIGN_REG_STATUS-={ Rejected} > }  TOTAL_VALUE)

Hope it helps,

Erich

Not applicable

Conditions to Set Analysis

Thanks Erich, for your time.

I am giving a try to the code that you have suggested,

Regards,

Bikash

Community Browser