Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sherineliz
New Contributor

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
New Contributor III

Re: Qlik Issue with date format

Try

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

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

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

  [Star Employee?])


Community Browser