topic Show all values in QlikView

Show all values

Thu, 02 Jul 2009 17:04:23 GMT

Hi *,

I'm trying to show all Sum values, even if they are Null for each Type.
This is working so far. As soon as I add a second dimension e.g. description (of Type),
I get every combination even if they don't exist. Is there a way to avoid this?

table should look like this:

Type Description Sum
1 Type_1 260
2 Type_2 100
3 Type_3 0
4 Type_4 0
5 Type_5 0
6 Type_6 0
7 Type_7 0
8 Type_8 0
9 Type_9 0
10 Type_10 0

The selection of a year should only change the sum field.

Anyone an idea?

Ps. Why is the last line of the table diagramm Type "-"

Thanks

Show all values

Thu, 02 Jul 2009 17:19:05 GMT

Is it what you wanted to achieve ?

I changed the script and some parameters in the table chart.

Philippe

Show all values

Thu, 02 Jul 2009 18:18:34 GMT

Hi Phillipe,

thanks for your help.

I'd like to display all types their description and the sum for each type, even if its null (all types should be shown).

If I select a year, the null values still should be shown.

Show all values

Thu, 02 Jul 2009 19:40:26 GMT

guess it's a problem to display values, selected by a date field when they actually don't exist and therefor no date filed exists.