Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qlik Issue with date format

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?

1 Reply
francescoreggia
Partner - Contributor III
Partner - Contributor III

Try

Count({<DateType = {'15'},

  [Join Date]={'>$(=num("31/03/2017"))'},

  [Star Employee?]={'Yes'}>}

  [Star Employee?])