topic Show date in QlikView

Show date

Anonymous — Wed, 08 May 2013 13:47:22 GMT

Hi all,

To answer a certain question I need to find a date within a month, based on a calendar.

What I would like to have is this:

Month	First saturday	Second saturday	Third saturday	Fourth saturday	Fifth saturday
01	05-01-2013	12-01-2013	19-01-2013	26-01-2013	-
02
03
04
05

Could anyone explain to me how I can find these dates with an expression?

I will need this date to use it in a variable.

Thanks.

Henco van Ee

Re: Show date

kaushiknsolanki — Wed, 08 May 2013 13:53:26 GMT

Hi,

If you only want Saturday then you can do this in script like shown below.

Load Date, if(inweek(Date,Monthstart(Date)),if(WeekDay(Date)='Sat',1)) as First_Sat_Flag

From xyz;

Regards,

Kaushik Solanki

Re: Show date

Anonymous — Thu, 09 May 2013 07:53:53 GMT

Hi Kaushik,

Thanks for your reply. I tried your suggestion, but unfortunately I can´t get it done.

I attached an example document, I hope you would like to take a look at it?

Thanks in advance.

Kind regards,

Henco

Re: Show date

er_mohit — Thu, 09 May 2013 09:03:59 GMT

Try this

Load Date, if(inweek(Date,Monthstart(Date)),if(Date(Date,'WWW')='Sat',1)) as First_Sat_Flag

From xyz;

hope it helps

Re: Show date

Thu, 09 May 2013 09:34:56 GMT

Hey Mate,

Kaushiks did not work for you because your system settings for daynames has set 'sat' to 'za'. I've attached a complete solution that gives you the saturday appearance for each calendar month.

If anyone knows a simpler approach, would love for you to show us

Otherwise, hope this is what you were looking for

Cheers,

Byron

Message was edited by: Byron_van_wy Edit Done - For completeness I added a pivot table with the set analysis 🙂

Re: Show date

Thu, 09 May 2013 10:24:42 GMT

try this see attached.

Re: Show date

anandathome — Thu, 09 May 2013 11:11:47 GMT

Hi Hanco,

Try thr below application

-Anand

Re: Show date

Gysbert_Wassenaar — Thu, 09 May 2013 11:44:08 GMT

Try one of the fields created with this:

Calendar:

Load

Date

,WeekDay(Date) as WeekDay

,ceil(Day(Date)/7) as Week

,if(WeekDay(Date)='za', ceil(Day(Date)/7)) as SatNum

Resident Calendar_tmp;

See attached example.