Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

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!

Highlighted
Master II
Master II

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?

Highlighted

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'))
Highlighted
Partner
Partner

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
      )