Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

antoniodneto
Contributor

HOW TO RANK DATE AND VALUE

Hi guys!!

I got this table:

rankear.png

There is showing the TOP and LAST DATES following the expression below:

='+' & max(aggr(if(rank(sum(RISCO_C_11_14 + RISCO_D_15_30)/Sum(RISCO_EM_DIA_LAG1),4)=1,DATA_BASE),DATA_BASE))

& chr(10) &

'-' & min(aggr(if(rank(-(sum(RISCO_C_11_14 + RISCO_D_15_30)/Sum(RISCO_EM_DIA_LAG1)),4)=1,DATA_BASE),DATA_BASE))


And now I'm trying to show also que value of the SUM with the DATE, how can I put the expression with?

Tks!!!

4 Replies
zebhashmi
Valued Contributor

Re: HOW TO RANK DATE AND VALUE

look like you can keep adding sum for value and max fro date almost similar you did.

antoniodneto
Contributor

Re: HOW TO RANK DATE AND VALUE

Yeah I'm think so! But I can't set into the sentence, I doing something wrong

zebhashmi
Valued Contributor

Re: HOW TO RANK DATE AND VALUE

Do you need rank inside the if?

antoniodneto
Contributor

Re: HOW TO RANK DATE AND VALUE

I need to show the top and last date and value for example, not just the date.

+201703 - 3.8% - 201701 - 5,6%


Tks!