Discussion board where members can get started with Qlik Sense.
I need some help about Min() and Max() function
in the code below i hope to get only one value, in this case the max value, but i receive more then that.
MAX(DATE_READ) AS DATA_FIM
WHERE FLOOR(DATE_READ)='19/03/2017' OR FLOOR(DATE_READ)='04/04/2017'
DROP TABLE CONCAT_TABLE;
Thank you all
Go to Solution.
I found the problem, I can not use group by to variable that i want to get a measure like max or min. So simple that i didn't saw it.
May be this
WHERE (FLOOR(DATE_READ)='19/03/2017' OR FLOOR(DATE_READ)='04/04/2017') AND ID_LEITURA='20|1|0'
Hi Andrey, i cant put a fixed value to this variable