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 want to calculate Max No of transactions on a any date.
Please suggest expression as KPI
Here is the sample data:
Date format is MM/DD/YYYY
LOAD * Inline [1, 12/03/20202, 12/04/20203, 12/04/20204, 12/04/20205, 12/04/20206, 12/04/20207, 12/04/20208, 12/05/20209, 12/05/202010, 12/06/2020]
Result Should be : 6
If your field is ID and second field is Date; this expression should work.
View solution in original post
I was near to this but couldn't achieve.