topic Chart properties in QlikView

Chart properties

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

In the above chart there is no sales on July month. So Target also not coming.

Even if there is no sales also i have to display Target.

Is this data model issue or chart issue. Black Colour bar is Target.

Transaction Started on June month .So there should not be a target before to June month

Re: Chart properties

Anonymous — Mon, 18 Apr 2016 11:33:36 GMT

Can you share whit us your data model ?

Re: Chart properties

sunny_talwar — Mon, 18 Apr 2016 11:34:50 GMT

What is your expression you are using for Target? If you have an if statement (or set analysis on sales field) restricting the Target expression to only show when there is sales, then I guess remove the if statement (or the set analysis). If there is no if statement, then this must be because of data issue

Re: Chart properties

Mon, 18 Apr 2016 11:45:23 GMT

Hi Kumaran

It is definitely a data issue.

If you dont have data captured for the month of July, nothing will reflect on the chart

You can create a constant value for Target when you load the data

MyTable:

Load

20 as Target

From

SourceTable

Target will then be created with the value 20 for all rows, even for July