Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Set Analysis 'is not null'

Hi,

I have a set analysis question. The existing, working expression I have is:

          Sum({$<EVENT.ACTVTY_CDE={LEGALACT,HOLD,PYMNT,DEFER}>} BILLM_ME.TOTAL_AR)

Unfortunately this is returning a slightly high figure, so I'm trying to restrict this further by only including figures where the EVENT_DETAILS.CLOSE_DATE is not null. I know that there isn't really an 'is not null' in Qlikview so am trying to work around this by only selecting records where the close date is greater than 01 Jan 1900. Can anyone tell me what's wrong with the following expression? This currently returns £0.00

           Sum({$<EVENT.ACTVTY_CDE={LEGALACT,HOLD,PYMNT,DEFER}, EVENT_DETAILS.CLOSE_DATE={">1900-01-01 00:00:00"}>} BILLM_ME.TOTAL_AR)

Thanks in  advance, Gavin

5 Replies
Highlighted
Partner
Partner

Hi

Try this Expression

Sum({$<EVENT.ACTVTY_CDE={LEGALACT,HOLD,PYMNT,DEFER}, EVENT_DETAILS.CLOSE_DATE={"> $(=Date(makedate(1900,1,1))"}>} BILLM_ME.TOTAL_AR)

Highlighted
Not applicable

Thanks, but unfortunately that doesn't return any data (now a dash '-' rather than 0)?

Gavin

Highlighted
MVP & Luminary
MVP & Luminary

Hi,

     Try this.

     Sum({$<EVENT.ACTVTY_CDE={LEGALACT,HOLD,PYMNT,DEFER}, EVENT_DETAILS.CLOSE_DATE={"$(=not isnull(EVENT_DETAILS.CLOSE_DATE))"}>} BILLM_ME.TOTAL_AR)

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Partner
Partner

Hi

Try this Expression

Sum({$<EVENT.ACTVTY_CDE={LEGALACT,HOLD,PYMNT,DEFER}, EVENT_DETAILS.CLOSE_DATE={ ' >$(=Date(makedate(1900,1,1)))'}>} BILLM_ME.TOTAL_AR)

Highlighted
Not applicable

  I'm afraid I've been a little hasty in posting. On further analysis it looks like events falling into the categories described will always have a close date set to null, so my original zero value was correct...Sorry to have wasted time, but I have learnt more about Set Analysis and null values from your answers and I think others also will, so answers marked as helpful (unfortunately only two 'helpful's allowed|). Thanks, Gavin.