I am quite new to Qlik and currently I am facing an issue with date formatting.
My query is as below:
Count({<DateType ={'15'},
[Join Date]={'>31/03/2017'},
[Star Employee?]={'Yes'}>}
[Star Employee?])
Count({<DateType ={'15'},
[Join Date]={'>31/03/2017'}>}
[Star Employee?])
This doesn't pupolate any value at all in my qlik report KPI box. However, if I remove the 2 lines
[Join Date]={'>31/03/2017'},
from the query then it does populate the number. So I guess it has to do with the date formatting. The data set pulls data from sql server. This however does populate a number if I pull the data from MS Access.
