topic Re: Show only complete MAT periods in chart in QlikView

Show only complete MAT periods in chart

Wed, 25 Nov 2020 16:16:04 GMT

Hi, I'm new to QV, and I have no scripting abilities, but I have to deliver a chart showing the MAT monthly sales figure.

I've already achieved the MAT calculation using an AsOf table, and have the chart plotted:

The problem is that it shows incomplete MAT periods (i.e. as I only have data until June-16, the following months have just 11, 10, 9, 8... months of sales data). As these MAT periods are not complete, I want to remove them from the chart.

Any clues how to do this?

Thanks for your help!

Re: Show only complete MAT periods in chart

sunny_talwar — Thu, 28 Jul 2016 19:09:34 GMT

What is the expression that you have used?

Re: Show only complete MAT periods in chart

Thu, 28 Jul 2016 20:05:45 GMT

Hi Sunny,

In the AsOf table, each month is related to the corresponding MAT period. I'm using the MAT period as dimensión, so the expression is just a SUM function of the sales amount: sum(VI)

Hope this helps,