topic Re: current month in QlikView

current month

raadwiptec — Wed, 25 Nov 2020 16:16:04 GMT

hi all,

I have a column named opening date for ex:

Temp2:

Load

[invoice no,]

[Opening date],

Charges

Quantity

Resident temp1;

store temp2 into C;/.......qvd

i need to have opening dates only for previous month..

As iam storing only in QVD ... i will nt be using any fron end expressions ...

nbeed solution on script level?

kindly suggest..

Re: current month

Mark_Little — Thu, 14 Jul 2016 12:57:33 GMT

Do you just want to store only previous month?

Something like

Temp2:

Load

[invoice no,]

[Opening date],

Charges

Quantity

Resident temp1

WHERE MONTH([Opening date]) = ADDMONTHS(Today().-1) ;

store temp2 into C;/.......qvd

Mark

Re: current month

Thu, 14 Jul 2016 12:57:38 GMT

Hi,

Use where statement like Opening date <= Current month start date.

Thanks

Siva

Re: current month

Anonymous — Thu, 14 Jul 2016 12:58:34 GMT

Try using a where statement such as:

where [Opening date] between monthstart(addmonths(Today()-1)) and monthend(addmonths(Today()-1))

Haven't checked the syntax properly but something along those lines.

Re: current month

danansell42 — Thu, 14 Jul 2016 13:02:54 GMT

If you wanted all data up until the end of last month i would try the following:

Temp2:

Load

[invoice no,]

[Opening date],

Charges

Quantity

Resident temp1

where [Opening date] < date(monthstart(today())) ;

Re: current month

raadwiptec — Thu, 14 Jul 2016 13:46:10 GMT

hi all,

i tried all the options it dos not work..mark suggestion gives no data

daniel suggestion gives complete data..

any other suggestions?

Re: current month

Mark_Little — Thu, 14 Jul 2016 13:51:14 GMT

HI,

Try wrapping the opening date field in a date function to rule out formatting issues. If it isn't being picked up as a date field then month function won't work.

Mark

Re: current month

raadwiptec — Thu, 14 Jul 2016 13:54:45 GMT

mark can you give me with an example...? my date format is 24-jan-2011 something like this

Re: current month

pooja_sn — Thu, 14 Jul 2016 13:58:40 GMT

Why don't you filter the data according to the condition on 'Opening Date' when you load it into Temp1 ?

Re: current month

Anonymous — Thu, 14 Jul 2016 13:59:06 GMT

As Mark pointed out try something like:

where Date([Opening Date]) between monthstart(addmonths(Today()-1)) and monthend(addmonths(Today()-1))

Re: current month

Mark_Little — Thu, 14 Jul 2016 14:01:05 GMT

HI,

Check that you date format is set correct on the main tab.

SET DateFormat='DD/MMM/YYYY';

MONTH(DATE(ADDMONTHS(TODAY(),-1),'DD/MMM/YYYY')) in the where,

Any doubts, add text boxes in the UI and see what the functions return and make sure they are like for like.

Mark