Discussion board where members can get started with Qlik Sense.
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.
Go to Solution.
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.
where month(Date) <= month(Today())
You can compare any date with following expression:
it will return 1st day of the current month.. so you can compare it by using Field1 <= monthstart(TODAY()) .....
Hope it helps.