Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

Expression error

Hi,

I have used the below expression but it is not working.

Logic:

if([Calendar Date]>= date('31-May-2018'),'DD-MMM-YYYY') and [Calendar Date]<=date(max([Calendar Date],'DD-MMM-YYYY'),num(Sum({$< [PA Age Days 365 Flag]= {'Y'},[Monthly Snapshot Flag]= {1},[%Confirmed PA Flag]={'Y'}>}[# PA Open]),'#,##0',null()))

Thanks..

1 Solution

Accepted Solutions
ChennaiahNallani
Creator III
Creator III

try like this

if([Calendar Date]>= date('31-May-2018','DD-MMM-YYYY')

      and [Calendar Date]<=date(max([Calendar Date],'DD-MMM-YYYY')),

        num(Sum({$< [PA Age Days 365 Flag]= {'Y'},[Monthly Snapshot Flag]= 1,[%Confirmed PA Flag]={'Y'}>}[# PA Open]),'#,##0')

            ,null())

View solution in original post

4 Replies
tresesco
MVP
MVP

One correction could be like:

if([Calendar Date]>= date#('31-May-2018','DD-MMM-YYYY') and ....


Note, date#() and a bracket correction..

prma7799
Master III
Master III

try this

if([Calendar Date]>= date('31-May-2018','DD-MMM-YYYY') and [Calendar Date]<=date(max([Calendar Date]),'DD-MMM-YYYY'),

num(Sum({$< [PA Age Days 365 Flag]= {'Y'},[Monthly Snapshot Flag]= {1},[%Confirmed PA Flag]={'Y'}>}[# PA Open]),'#,##0',null()))

balabhaskarqlik

Try this:

if([Calendar Date]>= date#(('31-May-2018'),'DD-MMM-YYYY') and

   [Calendar Date]<= date#(max([Calendar Date]),'DD-MMM-YYYY'),

   num(Sum({$<[PA Age Days 365 Flag]= {'Y'},[Monthly Snapshot Flag]= {1},[%Confirmed PA Flag]={'Y'}>}

           [# PA Open]),'#,##0'),null())

Bracket misplaced in 3 places.

ChennaiahNallani
Creator III
Creator III

try like this

if([Calendar Date]>= date('31-May-2018','DD-MMM-YYYY')

      and [Calendar Date]<=date(max([Calendar Date],'DD-MMM-YYYY')),

        num(Sum({$< [PA Age Days 365 Flag]= {'Y'},[Monthly Snapshot Flag]= 1,[%Confirmed PA Flag]={'Y'}>}[# PA Open]),'#,##0')

            ,null())