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)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
I want to count rows where week1 column <= week2 column
This is what i tried but it shows 0 as a result !
LOAD id from[table.xlsx] where
Date( MakeWeekDate(year(now()),Replace(week2,'S','')),'MM/yyyy' ) ;
I write count(id) in my Text object expression : IT shows me Zero while i have 2 rows matching with my where condition !
PS: Date( MakeWeekDate(year(now()),Replace(week2,'S','')),'MM/yyyy' ) : this expression is correct
Exemple : Week1 = S1 = 01/2021
I appreciate you help !
I figured out the problem :
My second column (week2 ) name was divided on 3 parts separated like this [ date plannified installation ] i hv concatenated to be [ DatePlannified installation ] writed in 2 parts and it works .
View solution in original post
the code i write in my question is correct if any one need it 🙂