topic Re: Week in QlikView

Week

NavinReddy — Tue, 23 Jul 2013 08:50:37 GMT

Hi Community,

I have Week table

How should i find out date start from Sundays-Saturday

could some one help me

Thanks in Advance

rohith

Re: Week

kaushiknsolanki — Tue, 23 Jul 2013 09:07:56 GMT

Hi,

You can create a flag in script which will number the days starting from Sunday to Saturday.

Below code will help you to create a flag

Let vMin = num(MakeDate(2012,01,01));
Let vMax = num(MakeDate(2012,12,21));

Load Date($(vMin) + RowNo() -1) as DATE,
WeekDay(Date($(vMin) + RowNo() -1)) as WEEKDAY,
if(num(WeekDay(Date($(vMin) + RowNo() -1)))=6,1,NUm(WeekDay(Date($(vMin) + RowNo() -1)))+2) as WEEK_NUM
AutoGenerate 1
while Date($(vMin) + RowNo() -1) < Date($(vMax));

Regards,

Kaushik Solanki

Re: Week

NavinReddy — Tue, 23 Jul 2013 09:38:34 GMT

Hi kaushik,

No need to be display every thing

Latest week should only i need to be disyplay

Thanks

Rohith

Re: Week

kaushiknsolanki — Tue, 23 Jul 2013 09:40:47 GMT

Hi,

Sorry I didnt got what you mean by everything,

Regards,

Kaushik Solanki

Re: Week

NavinReddy — Tue, 23 Jul 2013 09:50:26 GMT

Hi,

From that table i need to be display last week of data(Sunday-Saturday)

Thanks,

rohith

Re: Week

kaushiknsolanki — Tue, 23 Jul 2013 09:53:12 GMT

Hi,

Do you mean to say that you only want to show the Sunday and Saturday's Date and its relevant data?

Regards,

Kaushik Solanki

Re: Week

NavinReddy — Tue, 23 Jul 2013 10:09:11 GMT

Yes,exactly kaushik

Previous Week (Mar 7, 2013 - Mar 14, 2013) format

Re: Week

kaushiknsolanki — Tue, 23 Jul 2013 10:13:34 GMT

So,

If you mean you want to show only the last week data in chart then use the following set analysis.

Sum({<Date = {">=$(=Date(WeekStart(Today())-7)<=$(=date(weekend(today())-7))"},Month=Year=,Week=>}Sales)

If you dont want that data at all in the application, you can filter the same way when you are loading the data.

Regards,

Kaushik Solanki

Re: Week

NavinReddy — Tue, 23 Jul 2013 10:42:09 GMT

Thank you Kaushik

Re: Week

NavinReddy — Tue, 23 Jul 2013 10:50:15 GMT

Hi kaushik,

i have two expressions ,these are in right side of chart

How can i set these expression in buttom of the chart

thanks,

rohith

Re: Week

kaushiknsolanki — Tue, 23 Jul 2013 10:58:23 GMT

Hi,

Make that chart as Pivot table and then drag the expressions to row level.

Regards,

Kaushik SOlanki

Re: Week

NavinReddy — Tue, 23 Jul 2013 11:08:51 GMT

Hi,

Actually these two expression im using Barchat,How can i set

plz help me

Thanks,

rohith

Re: Week

kaushiknsolanki — Tue, 23 Jul 2013 11:10:32 GMT

Hi,

Do you mean you want legends to be at the bottom of the chart.

If yes then click on the chart press Shift+Ctrl and then drag the legend to the bottom of the chart.

Regards,

Kaushik Solanki

Re: Week

NavinReddy — Tue, 23 Jul 2013 11:12:15 GMT

kaushik Thank you so much working fine