topic Re: Chart in QlikView

Chart

Thu, 17 Mar 2016 07:15:51 GMT

Hi Experts,

I have created a Master Calendar but I don't have data for some months. Now I want to display blank even there is no data. How to achieve this?

Thanks

Re: Chart

Gysbert_Wassenaar — Thu, 17 Mar 2016 07:22:57 GMT

Have you tried disabling the Suppress Zero-Values and Suppress Missing options in the chart properties?

Re: Chart

Thu, 17 Mar 2016 07:41:44 GMT

Yes, I tried no change

Re: Chart

t_chetirbok — Thu, 17 Mar 2016 07:50:17 GMT

Hi!

find the attachment

I think it is that you want

Re: Chart

jagan — Thu, 17 Mar 2016 07:53:26 GMT

Hi,

Try like this

Dimension: Month

Expression =Sum(Sales) + (Sum({1} Sales) * 0)

Regards,

Jagan.

Re: Chart

avinashelite — Thu, 17 Mar 2016 07:55:10 GMT

try to check the show all values in the Dimension tab

Re: Chart

Gysbert_Wassenaar — Thu, 17 Mar 2016 08:01:19 GMT

Please post a small qlikview document that demonstrates the problem.

Re: Chart

smirkinaa — Thu, 17 Mar 2016 09:31:37 GMT

Hi, you need to fill the gaps in your Master Calendar or you can create it without using fact table.

// example of creating Master Calendar

LET vStartDate = Num('01.01.2014');

LET vEndDate = Num(Today());

MasterCalendarPrepared:

LOAD

$(vStartDate) + RowNo() as Date

AutoGenerate $(vEndDate) - $(vStartDate);

MasterCalendar:

LOAD

Date(Date) as DatePresentation,

Year(Date) as DateYear,

Month(Date) as DateMonth,

MonthName(Date) as DatePeriod

Resident

MasterCalendarPrepared;

DROP Table MasterCalendarPrepared;

Then you can rename key field and establish connection between Master Calendar and fact table.