2 Replies Latest reply: Sep 5, 2016 6:13 AM by Frank Weller RSS

    Set Analysis with combined date and rank

    Frank Weller

      Hallo,

       

      I'm trying to get a set analysis right (in QLIK Sense) to display the top candidates for today, yesterday etc.

       

      That works and displays the entries from today correctly:

      count( {$ <myDate= {"$(=date(today(1),'DD/MM/YYYY'))"} > } myName)

       

      That works and displays my top 10:

      Count({<myName= {"=rank(count({<myCondition= {'A','B'}>}myName), 4)<= 10"}>} myName)

       

      However I'm tried in vain to get the top 10 of today's entries

      Count({<myName= {"=rank(count({$ <myDate= {"$(=date(today(1),'DD/MM/YYYY'))"} > } myName), 4)<= 10"}>} myName)

       

      Can anyone help me please.Many thanks in advance.