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
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ajinkyabhonsle
Contributor III
Contributor III

Default to current fiscal year

Hi All,

I need to show data in a line graph for the current fiscal year-FY20 (fiscal year starts from Feb'19-Jan'20). 

The values in the Fiscal Year = FY20,FY19,FY18,FY17...

I want to write a set analysis to show only FY20 data. The measure in my graph is

Count({<Enabled = {'1'},Classification = {'CUSTOMER'}>} distinct Keys) and Dimension is Fiscal Year. How should I make this graph to show only FY20 data?

1 Solution

Accepted Solutions
Vegar
Partner
Partner

Try something like this... 

Count({<

   Enabled = {'1'},

  VClassification = {'CUSTOMER'},

   [Fiscal Year] = {'$(=maxstring([Fiscal Year]))'}

>} distinct Keys) 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

1 Reply
Vegar
Partner
Partner

Try something like this... 

Count({<

   Enabled = {'1'},

  VClassification = {'CUSTOMER'},

   [Fiscal Year] = {'$(=maxstring([Fiscal Year]))'}

>} distinct Keys) 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post