topic Re: date dimention in table in QlikView

date dimention in table

adiarnon — Sun, 08 Jun 2014 14:13:44 GMT

hi,

i have this table in my scheme-

date	name
1.1.14	A
2.1.14	B
3.1.14	A
4.1.14	A
5.1.14	B
6.1.14	A
7.1.14	B

and this table in my model (PIVOT)-

name	1.1.14	2.1.14	3.1.14	4.1.14	5.1.14	6.1.14	7.1.14
A	1		1	1		1
B		1			1		1

if im filtering only on name 'A' its giving me only the date (1.1.14, 3.1.14, 4.1.14, 6.1.14) and 1 in all the columns

i whant that it will show me all tha dates not just the date that A active...

i tried show all values

and i unchacked the supress null...

help please,

Re: date dimention in table

jonathandienst — Sun, 08 Jun 2014 18:10:01 GMT

You can do this with a disconnected (island) table. Because the island date field is not connected to the main table, selecting a name does not reduce the possible date values. See the attached example.

HTH

Jonathan

Re: date dimention in table

Mon, 09 Jun 2014 07:11:19 GMT

Hello,

Why do not you use Pivot table with date and name as dimension and 1 as expression. And then drag the date field to vertical.

Thanks.

Angad