This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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.
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.
View solution in original post
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.