Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
buzzy996
Master II
Master II

chart expression

hi,the below syntax is working perfectly fine with straight table but i need to implement the same on chart and most important " need to consider only met possible records" on chart .

 

=IF(

      IF(Len(ord_Date_Time__c)<1,

          Date(Today(),'dd/MM/yyyy'),Date(ord_Date_Time__c,'dd/MM/yyyy')

         )

        < Date(IDate__c + If(Agent='PTO','28','91'),'dd/MM/yyyy'),'Met','Not Met'

      )

 thanks in advance

4 Replies
bgerchikov
Partner - Creator III
Partner - Creator III

First, I'd avoid to use formatted Dates. Try to use numeric values.

If you want to exclude 'No Met' values, use Null() instead and set to exclude Null values in chart

=IF(
      IF(Len(ord_Date_Time__c)<1,
          Floor(Num(Today())),Floor(Date(ord_Date_Time__c))
         )
        < (Num(IDate__c) + If(Agent='PTO',28,91)),'Met',Null()
      )

Good luck!

buzzy996
Master II
Master II
Author

hi,thanks for this but it's not helped to me because need to use on expression tab (not on dimension tab to control null values)

 I just need to count of all met from the above expression on bar chart & tht to on expression tab.

any other idea?

sunny_talwar

May be try this

=Count(If(If(Len(ord_Date_Time__c) < 1, Today(), ord_Date_Time__c) < (IDate__c + If(Agent = 'PTO','28','91')), 'Met'))

or this

=Count(If(Alt(ord_Date_Time__c, Today()) < (IDate__c + If(Agent = 'PTO','28','91')), 'Met'))
bgerchikov
Partner - Creator III
Partner - Creator III

I see. What about this:

=Sum(
      IF(Len(ord_Date_Time__c)<1,
          Floor(Num(Today())),Floor(Date(ord_Date_Time__c))
         )
        < (Num(IDate__c) + If(Agent='PTO',28,91)),1
      )