topic Re: Set Analysis with combined date and rank in App Development

Set Analysis with combined date and rank

Fri, 02 Sep 2016 06:04:53 GMT

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.

Re: Set Analysis with combined date and rank

sunny_talwar — Sat, 03 Sep 2016 18:40:25 GMT

Try this:

In the script use Date() function around myDate so that it gets assigned the default Date() function in the script. Once it gets default assigned, you won't have to use Datefield format in the expression above.

LOAD Date(myDate) as myDate,

....

FROM...

And then this:

Count({<myName= {"=Rank(Count({$<myDate= {'$(=Date(Today(1)))'}>} myName), 4) <= 10"}>} myName)

Re: Set Analysis with combined date and rank

Mon, 05 Sep 2016 10:13:00 GMT

Thank you Sunny, I tried it but it doesn't work.