topic Chart Requirement in QlikView

Chart Requirement

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

Hi All,

Please find the image below.

In my chart I have got Item with three category - Forecast , Invoice and Order.

Please check the first two item does have three categories but the last item 610106 is only having forecast have.

The reason is the item is not having data for invoice and order in the Qlikview Model.

How can I create dummy records for the mentioned item.

So that , The item will have Invoice and Order records as zero (0) in the chart.

Sample Model attached.

Your help is much appreciated.

Thanks in Advance.

MK_QSL — Tue, 21 Jun 2016 08:00:02 GMT

You can do something like this...

create a master calendar so that you don't have to use 10 to 12 expressions.

suvechha_b — Tue, 21 Jun 2016 08:36:53 GMT

Hi Manish,

Thanks for the sample .

Please can you resolve how to get the total

MK_QSL — Tue, 21 Jun 2016 09:15:53 GMT

Create Amount Type at back end for Item Code/Description for those Sales Month where you don't have relevant data. This will solve your problem.

suvechha_b — Tue, 21 Jun 2016 09:57:28 GMT

Hi Manish,

I am unable to do it.

Please , if you can help me in doing that in the sample model.

sample model attached.

If I select 2016 , the Chart is showing from 2019 , How to reflect data only for 2016 not for other fiscal year.

Your help will be much appreciated.

Thanks in Advance.