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 have a date field which consists of dates from 2020-01-01 to 2021-08-31
I want to create a new field which will show below values when used in filter
I tried it using if statement but not able to achieve the above expected results..
Any help would be really appreciated!
Try an IF statement like this
If(DateField>=makedate(2021,9),'>2021-08-31', If(Year(DateField)=2021,'2021', if(Year(DateField)=2020,'2020','<2020-01-01')))
Thanks for the reply!
Actually I want to make a code dynamic.
The solution you've provided includes hardcoding.
Then you would need to replace the har coded parts with some kind of logic.
Alternatively you could look into creating an interval table and then apply your groups using interval match.