Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys,
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.
What could I be possibly doing wrong?
Try
Count({<DateType = {'15'},
[Join Date]={'>$(=num("31/03/2017"))'},
[Star Employee?]={'Yes'}>}
[Star Employee?])