1 Reply Latest reply: Jul 11, 2018 11:52 AM by Francesco Reggiani RSS

    Qlik Issue with date format

    sherin t

      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?