topic Pivot table dates range display problem in QlikView

Pivot table dates range display problem

Thu, 16 Feb 2012 14:04:11 GMT

hi folks,

i have data from 2012 jan 1-29 days.

my problem is to show the dates range as 1-7 8-15 16-23 like that

i tried calculated dimension as-- date(weekstart(salesdate),'m.dd')&'-'& date(weekend(salesdate),'m.dd')

expression: sum(sales)

problem: its showing dates range from 26-1,1-8.....23-29.

requirement: range should start from 1st day of january

may be its problem in date format , i used subfield to achieve the desire date format

where exactly the problem

plz help me out

Pivot table dates range display problem

jagan — Thu, 16 Feb 2012 14:10:48 GMT

Hi,

If you use WeekStart it returns the Week starting date For Jan-1, the week start is 26-1.

Try this using

date(Lunarweekstart(salesdate),'m.dd')&'-'& date(Lunarweekend(salesdate),'m.dd')

Hope this helps you

Regards,

Jagan.

Pivot table dates range display problem

jagan — Thu, 16 Feb 2012 14:13:58 GMT

Hi,

Use this expression instead of the above, Date Format is fixed.

=Date(Lunarweekstart('1/1/2012'),'M.DD') &'-'& date(Lunarweekend('1/1/2012'),'M.DD')

Regards,

Jagan.

Pivot table dates range display problem

Fri, 17 Feb 2012 06:23:49 GMT

hi jagan,

thanks for ur reply

lunarweekstart solved problem , but last week range its showing 1-29 to 2-4 .

any alternative to restrict week range up to end of january

Thanks

Pivot table dates range display problem

vijay_iitkgp — Fri, 17 Feb 2012 07:00:23 GMT

Hi You can use:

=Date(Lunarweekstart('1/1/2012'),'M.DD') &'-'& If(date(Lunarweekend('1/1/2012'),'M.DD')<7,

date(MonthEnd('1/1/2012'),'M.DD'),date(Lunarweekend('1/1/2012'),'M.DD'))

Pivot table dates range display problem

Tue, 21 Feb 2012 06:09:58 GMT

hi ,

if i use max date as variable ,ie: date(max(Date), 'DD MMM YYYY').

how can i use my variable in this expression to achieve only january 1st to 29th

expression working on the use of transdate dimension only.

plz help me out

Pivot table dates range display problem

jagan — Tue, 21 Feb 2012 06:15:48 GMT

Hi,

try using the below expression

=Sum({<Transdate={'>=$(=MonthSart(vDate))<=$(=MakeDate(Year(vDate), Month(vDate), 29))'}>} Sales)

Regards,

Jagan.

Pivot table dates range display problem

Tue, 21 Feb 2012 06:26:00 GMT

hi jagan,

here vDate=max date or min date

how i can declare vDate as Variable.

here date starting from jan 1 to 29.

thanks jagan

Pivot table dates range display problem

CELAMBARASAN — Tue, 21 Feb 2012 06:56:17 GMT

Hi,

Press Ctrl+Alt+V.

In variable overview you can add variables.

add variable name as vDate.

value as =Max(Date)

Celambarasan

Pivot table dates range display problem

Tue, 21 Feb 2012 07:25:56 GMT

Hi,

Try inserting following dimension.

(TestDate need to be replaced by SalesDate / whatever dimension you have).

IF(MONTH(LunarWeekEnd(TestDate))<>MONTH(LunarWeekStart(TestDate)),NULL(),LunarWeekStart(TestDate)&'-'&DATE(LunarWeekEnd(TestDate),'DD/MM/YYYY'))

This will give you range of date before Jan end only.

Pivot table dates range display problem

jagan — Tue, 21 Feb 2012 07:53:37 GMT

Hi,

Attach the sample document, will help in fixing the issue.

Regards,

Jagan.

Re: Pivot table dates range display problem

Tue, 21 Feb 2012 09:58:14 GMT

hi gurus,

plz find the attached sample qvw.

in week off how to stop date range upto jan month only , not into feb

Re: Pivot table dates range display problem

Tue, 21 Feb 2012 11:52:23 GMT

Hi,

Please check attachment.

I hope this is what you want.

Re: Pivot table dates range display problem

Tue, 21 Feb 2012 12:21:29 GMT

hi ravi,

here iam missing one date value

plz find the attached qvw

Thanks in advance

Re: Pivot table dates range display problem

Tue, 21 Feb 2012 12:33:17 GMT

Hi,

Please refer to attachment.

Re: Pivot table dates range display problem

Tue, 21 Feb 2012 12:39:50 GMT

hi ravi, jagan

ur right , its worked for me

Thanks for quick responce