Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

philipp_kunz
Contributor

Calendar with deviating Startdate

Hi,

i hope some of you guys can help me.

The problem i have is, that i have a field (OrderDate) which contains Dates of several Orders.

Unbenannt.JPG

I now need do transform theses OrderDates in a way, that if i for example click on the  01.04.2012 it shows up the 26. of the previous month (26.03.2012)

Basically speaking i needto create a new Datefield that shows up the 26.12.2012 if i click on the 01.01.2013 and so on.

it should actually be a calendar that always starts at the 26. of the previous month.(swedish calendar)

could i make myself clear to you?

I hope someone can help.

1 Solution

Accepted Solutions
vaibsonly
Contributor II

Re: Calendar with deviating Startdate

Hi,

        PLz chk...

          Is tat wat u wanted???

        Revert back....

Regards,

Vaibz...

4 Replies
vaibsonly
Contributor II

Re: Calendar with deviating Startdate

Hi,

        PLz chk...

          Is tat wat u wanted???

        Revert back....

Regards,

Vaibz...

philipp_kunz
Contributor

Re: Calendar with deviating Startdate

Hey vaibhav c ,

this is exactly what i needed!

Many Thx!!

rustyfishbones
Honored Contributor II

Re: Calendar with deviating Startdate

You can create a List box Expression if you do not want to do this in the Script

Add Expression

DateExp.png

vaibsonly
Contributor II

Re: Calendar with deviating Startdate

Hey Welcome any time Philipp... :-)

Community Browser