Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
ajinkyabhonsle
New 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
Partner
Partner

Re: Default to current fiscal year

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
Partner
Partner

Re: Default to current fiscal year

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