Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Creator II
Creator II

Partner
Partner

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
Creator II
Creator II

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

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.
Creator II
Creator II

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?