topic Re: Chart missing dimensions in QlikView

Chart missing dimensions

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

I have created a chart with the following dimensions:

The expression for the chart is as follows:

The resulting chart is.below. The chart is not showing the months June, July, August and September. What could be wrong?

Re: Chart missing dimensions

Kushal_Chawda — Thu, 05 May 2016 07:26:31 GMT

May be you don't have amount for this Months or it is zero.

Re: Chart missing dimensions

saumyashah90 — Thu, 05 May 2016 07:39:17 GMT

hi,

This is the reason because you dont have data for those months(FMonth).

If you want to achieve the same you need to built master calendar.

Do inline

Just add this script have same field name

Load * Inline [

FMonth,Num

Jan,1

Feb,2

Mar,3

Apr,4

May,5

Jun,6

Jul,7

Aug,8

Sept,9

Oct,10

Nov,11

Dec,12

];

Re: Chart missing dimensions

sunny_talwar — Thu, 05 May 2016 08:25:10 GMT

On the similar lines, may be try unchecking 'Suppress-Zero Values' option to see if those months come up with 0 value

Re: Chart missing dimensions

Anonymous — Thu, 05 May 2016 08:25:54 GMT

Thanks Kushal

You are right there is something wrong with the expression and fiscal years. I changed the dimensions to calendar month and calendar year and expression to 'Sum(Amount)' and i get the following:

All months are represented so it is something to do with the fiscal calendar in my opinion.

Re: Chart missing dimensions

Anonymous — Thu, 05 May 2016 08:26:29 GMT

Many thanks Saumya, see my response to Kushal above.

Re: Chart missing dimensions

sunny_talwar — Thu, 05 May 2016 08:28:49 GMT

What if you remove the MonthsAgoYTD set analysis and use FMonth and FYear. Does that bring back those months? Just trying to check where might the issue be.

Re: Chart missing dimensions

Anonymous — Thu, 05 May 2016 08:39:38 GMT

You are right Sunny, i removed the expression with MonthsAgoYTD and replace with ordinary Sum(Amount) and this give the right chart.