topic Re: Showing columns with empty rows in tables in QlikView

Showing columns with empty rows in tables

Thu, 20 Feb 2014 21:53:42 GMT

Hi everybody,

I have a standard report with tables showing 6 months of data. For some clients, there is no enough data yet, So I would need to have a table like:

	Dec 2013	Jan 2014	Feb 2014	Mar 2014	Apr 2014
First visit	100	110
Daily	95	85
Weekly	47	57
Monthly	44	39
Less than once a month	9	7

My data is loaded from SQL and I can only show existing data

	Dec 2013	Jan 2014
First visit	100	110
Daily	95	85
Weekly	47	57
Monthly	44	39
Less than once a month	9	7

I tried to INLINE load months with no data, but no success.

Could you please help me to solve this?

Thank you very much!,

ILIA

Re: Showing columns with empty rows in tables

Thu, 20 Feb 2014 22:11:45 GMT

Try to disable in presentation tab of the table:

Suppress Zero Values

Suppress Null

Re: Showing columns with empty rows in tables

maxgro — Thu, 20 Feb 2014 22:14:11 GMT

in the attachment

Re: Showing columns with empty rows in tables

Fri, 21 Feb 2014 14:47:14 GMT

Thank you guys,

The visit counts are calculated from a separate table containing record ID and visit frequency value

Respondent ID is connected to MYear variable in a date format. I cannot INLINE load aggregated visit values like it was shown in the example, but thank you anyway.