topic Re: fiscal year in QlikView

fiscal year

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

hello everyone

i have one requirement, i want to show Q1,Q2,Q3,Q4 in a different chart and Q1,Q2,Q3,Q4 in a single chart(fiscal year) (it means total 5 chart)

i have fiscal year from 2010 to 2015 . my issue is while i select single year then it shows in a 5 charts but when i select 2 year simultaneously then it shows 2 years data in 4 chart but not in single chart(fiscal year).

when i select single year

when i select 2 year simultaneously

Thank you.

Re: fiscal year

Mark_Little — Thu, 23 Nov 2017 08:23:37 GMT

Hi,

Can you please share your expressions used.

I am guessing your deimension is your Quarter field, but not knowing the set analysis used in the expression we won't be able to advise what is wrong.

Mark

Re: fiscal year

Anonymous — Thu, 23 Nov 2017 08:35:14 GMT

sorry but i cant share it.

i am taking fiscal quarter as a dimension and in expression used if condition

Re: fiscal year

shanky1907 — Thu, 23 Nov 2017 09:15:00 GMT

Can you take Year as dimension also in the chart and check?

Re: fiscal year

Mark_Little — Thu, 23 Nov 2017 09:23:20 GMT

If you can't share your calculation then i won't be able to tell you what is wrong with it.

I am not asking for any data, just evening if you change the field names so we can see the syntax.

Something like

IF(Value =1,SUM(Amount))

Mark

Re: fiscal year

Anonymous — Thu, 23 Nov 2017 10:20:50 GMT

but it show data only for 1st year

Re: fiscal year

avinashelite — Thu, 23 Nov 2017 10:36:09 GMT

In both the charts your using the same Fiscal Quarter?? or calendar Quarter quater in one chart ??

Re: fiscal year

avinashelite — Thu, 23 Nov 2017 10:36:40 GMT

whats the expression for both the charts ?? same or different