show next weeks with zero

[gr_eldred]

show zeros forward

I have a pivot table object that shows the weeks of the first quarter of the year. We are in week four so nothing shows the weeks of the 4 weeks but I need to show the next weeks of the quarter even with a zero. Is this possible to do ?

Currently my object is like that?

I need this

Can somebody help me?

[tomasz_tru]

Just create 'dummy' dimmension with all the weeks you want to show. Autogenerate function may be handy.

Tomasz

[gr_eldred]

hi, my dimension has 52 weeks of the year the problem lies in sales, as we have not reached the following weeks I still can not show that period

[tomasz_tru]

My misunderstanding. It would work in Sense so there must be an option somewhere in QV

[gr_eldred]

I use Qlikview