Chart Requirement

[suvechha_b]

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]

You can do something like this...

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

[suvechha_b]

Hi Manish,

Thanks for the sample .

Please can you resolve how to get the total

[MK_QSL]

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]

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.