Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Vince_CH
Creator II
Creator II

problem with Canonical date in KPI

Dear friends,

as below two KPIs, to indicate the YTD production orders quantity, with KPI set by canonical date with datetype as "order" as showed in scripts right side. and second KPI just was with standard order calendar setting. 

it was no problem before to show the consistent results, but now as the time is approaching the end of our fiscal year, which means for same order for example, the plan date could be in next fiscal year, as different from the order calendar still in this fiscal year.  

so now the KPI set by the canonical date turned into zero instead. how can i achieve the same result as order date calendar did, but as per the canonical date??  thanks in advance!

 

11.jpg

 

 

5 Replies
Sameer9585
Creator II
Creator II

Vegar
MVP
MVP

I notice you are missing a comma after DateType={'Order'}.

It should be ... DateType={'Order'}, DateCan....
Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Vince_CH
Creator II
Creator II
Author

Hello Vegar, thanks, the comma was there, just was hidden by my yellow lines. sorry for that.
Vince_CH
Creator II
Creator II
Author

Hello Sameer, yes, have read this blog earlier, based on which i had created the scripts as you can see from my screen shot right side.
the point is, when all datetype are in same fiscal year, it is no problem to show the consistent results, but whenever one datetype is exceeding into next fiscal year, and some datetypes are still remains in current fiscal years, then it is the problem. because the Max(Year( Date_Can)) always pick up up the most future year, regardless some datetype are still within the current year, so the data are extracted in disorder.
Vince_CH
Creator II
Creator II
Author

the reason why i used canonical date is more easier to select by one button. but if there is no solution here, then i have to create more calendar buttons as per different datatypes in order, plan, finish etc. but it will be quite lengthy and complicated to choose between differentiation what from what.

so did anybody have the same experience and resolved this issue before?