Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rsingh43
Contributor

Current Month

Hi,

I would like to add a where clause to my data load editor to restrict data up to the current month. Can someone please assist me with how to add the below:

WHERE Date <= CurrentMonth

All the searches I have done in the forum only return calculations e.g. SUM

Thank you in advance for any assistance.

1 Solution

Accepted Solutions
ishanbhatt
Contributor II

Re: Current Month

Hi Raman,

If you want to restrict data up to the current month then use below mention solutions.

1. If you want to consider the whole month then,

          Where Date <= Monthend(Today())

2. If you want to load data up to today then,

          Where Date <= Today()

* Make sure that Date field format and system format are same.

4 Replies
gerry_hdm
Contributor II

Re: Current Month

where month(Date) <= month(Today())

greetings Gerry

rahulgoyal1287
New Contributor III

Re: Current Month

Hi Raman,

You can compare any date with following expression:

monthstart(TODAY())

it will return 1st day of the current month.. so you can compare it by using Field1 <= monthstart(TODAY()) .....

Hope it helps.

Best Regards,

Rahul

ishanbhatt
Contributor II

Re: Current Month

Hi Raman,

If you want to restrict data up to the current month then use below mention solutions.

1. If you want to consider the whole month then,

          Where Date <= Monthend(Today())

2. If you want to load data up to today then,

          Where Date <= Today()

* Make sure that Date field format and system format are same.

rsingh43
Contributor

Re: Current Month

Thanks, guys!

Community Browser