Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

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

Highlighted
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