How to show data that is 0 or null in line chart?

[#1]

Hi,

I have the following data in Qlikview data model. 

SA Record  No	Student ID	Year	SA QuestionMasterID	SA QuestionData
SA 1	12345A	2013	Title	This is a title 1
SA 1	12345A	2013	Publication	Details of title 1
SA 1	12345A	2013	Status	1
SA 1	22222B	2013	Title	Title 2
SA 1	22222B	2013	Publication	NA
SA 1	22222B	2013	Status	1
SA 1	33333C	2013	Title	Title A
SA 1	33333C	2013	Publication	NA
SA 1	33333C	2013	Status	1
SA 2	33333C	2014	Title	Title B
SA 2	33333C	2014	Publication	Details of Title B
SA 2	33333C	2014	Status	2

Below is the line chart output.  I need to show zero values for residents who have not attempt any activities.  These are records not found in the table:

Expression Used: =Aggr(COUNT(DISTINCT SA_Record_No),[Resident Full Name], [Year of Training])

I tried the following in presentation and dimensions tabs:

1) Unchecked Suppress Null values (Dimension Tab)

2) Checked Show All Values (Dimension Tab)

3) Unchecked Suppress Zero Values (Presentation Tab)

4) Checked Zero Bars (Presentation Tab)

Yet it din't show the expected result.  I saw other people in this forum did a count in their scripting.  It works for them as they have only numeric values.  For me I have both text and numeric values.  I tried to do a IsValue but it did not work.

Would like to ask for guidance on these.

There are some solutions below but it wont work in my context:

QlikView Zero Line Fix – Infinity Insight Blog

Chart show zero when no data for date

I put here so others can refer easily too.

Thanks

Chun Wey

[amit_saini]

Hi,

Check if this can help u:

NULL handling in QlikView

Thanks,
AS

[tresesco]

Can you post your sample qvw?

[#4]

Hi Tresesco,

Attached for your reference.  Please refer to Scholarly Activities Tab.

You can see the issue clearly for John Woo in Year 2014.

Thanks

Chun Wey

[amit_saini]

Hi,

Like this???

Thanks,
AS

[#6]

Nope, I need the line to go down to 0 at x axis for the student.

[#7]

Hi All,

Do need advise/ guidance on this.

Thanks

Chun Wey