Display in Tables

anthony_kinsell — Tue, 01 Jul 2014 11:27:17 GMT

Hi,

I am compiling data for a number of properties, all of which have both rental & service charge data. In my script I have identified which properties are rental & which are service charge by their references & have created a field called 'Group' which has 2 possible results - rent & service charge & all of this works fine.

What I am now trying to do is gather data in a table - lay-out as below - property is my dimension:

Property	YearMonth	Jan-14	Feb-14	Mar-14	Apr-14	May-14	Jun-14	Jul-14
Property A
Property B
Property C
Property D
Property E
Property F
Property G
Property H
Totals:

The issue I have is as follows:

I want to show all properties (A-H) regardless of whether there is data for that month or not (I also want to show all month).
If in my settings I tick the 'show all values' box on the property dimension I get both rental & service charge properties - i.e. it ignores my selection in my 'Group' field

How do I get around this? Do I need a calculated dimension rather than simply choosing the Property field as my dimension?

Thanks

Re: Display in Tables

Tue, 01 Jul 2014 13:55:51 GMT

Do you use the pivot table? If so, you should untick "supress zero values" in the presentation chart.

Re: Display in Tables

anthony_kinsell — Tue, 01 Jul 2014 13:57:47 GMT

I am using a pivot table yes – suppress zero values isn’t ticked

topic Re: Display in Tables in QlikView

Display in Tables

Re: Display in Tables

Re: Display in Tables