Empty weeks

Anonymous — Tue, 17 Feb 2015 20:17:53 GMT

Hi,

I have a problem. I want to see empty weeks.

Checked all dates,i see all weeks in selection:

For example: with selection in column Orderer = Orderer1, i need to see empty week 4:

How i have to show all weeks in selection MASTER CALENDAR (FROM - TO) with empty weeks (show '-')?

Re: Empty weeks

Anonymous — Tue, 17 Feb 2015 20:37:02 GMT

If you check your data model you will find that when Orderer=Orderer1, there is no date corresponding to week 4 that's why you can not see week 4. The dimension value for week 4 does not exist when Orderer=Orderer1.

2014.01.02	Orderer1	1	526.61	1
2014.01.02	Orderer1	2	1001	1
2014.01.03	Orderer1	3	687.73	1
2014.01.04	Orderer1	4	1271.9	1
2014.01.05	Orderer1	5	1876.5	1
2014.01.06	Orderer1	6	787.31	2
2014.01.07	Orderer1	7	655.46	2
2014.01.08	Orderer1	8	629.67	2
2014.01.09	Orderer1	9	1641.4	2
2014.01.10	Orderer1	10	1706.9	2
2014.01.11	Orderer1	11	30.49	2
2014.01.12	Orderer1	12	1561.9	2
2014.01.13	Orderer1	13	781.65	3
2014.01.14	when	14	1335.2	3
2014.01.15	Orderer1	15	219.35	3
2014.01.16	Orderer1	16	1833.3	3
2014.01.17	Orderer1	17	1125.2	3
2014.01.28	Orderer1	28	1882.6	5
2014.01.29	Orderer1	29	268.16	5
2014.01.30	Orderer1	30	525.87	5
2014.01.31	Orderer1	31	1405.8	5
2014.02.01	Orderer1	32	1363	5
2014.02.02	Orderer1	33	156.46	5
2014.02.03	Orderer1	34	629.89	6
2014.02.04	Orderer1	35	1103.9	6
2014.02.05	Orderer1	36	1637.1	6
2014.02.06	Orderer1	37	736	6
2014.02.07	Orderer1	38	695.24	6
2014.02.08	Orderer1	39	951.58	6

topic Re: Empty weeks in QlikView

Empty weeks

Re: Empty weeks