topic chart expression in QlikView

chart expression

buzzy996 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: chart expression

bgerchikov — Thu, 03 Jan 2019 18:01:52 GMT

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!

Re: chart expression

buzzy996 — Fri, 04 Jan 2019 11:31:58 GMT

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?

Re: chart expression

sunny_talwar — Fri, 04 Jan 2019 13:05:35 GMT

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

Re: chart expression

bgerchikov — Fri, 04 Jan 2019 16:55:09 GMT

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
      )