Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-02-23 07:02 AM

Fiscal Year

Hello everyone,

i want to calculate YTD for that i have year,month,region,kpi & value field.

I have two different region INDIA & US.

If i simply calculate then its shows proper value for US but not for INDIA.

If i used FY for INDIA the it will be show proper value but i am not getting where and how to used fiscal year for INDIA.

Please help me to find out.

Thanks..

200 Views
0 Likes
1 Reply
Peter_Cammaert
Partner - Champion III
Partner - Champion III
‎2018-02-23 08:00 AM

You may want to use an ASOF table and Canonical dates. See

https://community.qlik.com/blogs/qlikviewdesignblog/2015/11/02/the-as-of-table

Qlik Design Blog : Canonical Date | Qlik Community

Although I don't understand how you can use FY for INDIA to get proper results while at the same time not knowing how to use FY for INDIA to calculate results. You didn't do this calculation in your QlikView document ?

135 Views
0 Likes