topic Re: Bottom 5 in QlikView

Bottom 5

varunreddy — Mon, 11 Jul 2016 17:14:12 GMT

Hi All,

I am trying to display top 5 Assessment Names and Bottom 5 Assessment Names as of Latest Date Available.

Expression used for Top 5:

Only({<Date>} aggr(sum({<Date,

[Assessment Name] = {"=rank(sum({<Date= {'$(vCurMonthYear)'}>}1-([Total Number of Failing Records]/[Total Number of Records])))<=5"}

>}1-([Total Number of Failing Records]/[Total Number of Records])),Date,[Assessment Name]))

This is working fine

Expression for Bottom 5:

Only({<Date>} aggr(sum({<Date,

[Assessment Name] = {"=rank(-sum({<Date= {'$(vCurMonthYear)'}>}1-([Total Number of Failing Records]/[Total Number of Records])))<=5"}

>}1-([Total Number of Failing Records]/[Total Number of Records])),Date,[Assessment Name]))

This is not displaying any data.

I need to see bottom 5 values.

Thanks in advance!

Regards,

Varun

Re: Bottom 5

sunny_talwar — Mon, 11 Jul 2016 17:17:21 GMT

Is it possible that bottom 5 have all 0 values for some reason?

Re: Bottom 5

varunreddy — Mon, 11 Jul 2016 17:19:22 GMT

Sunny,

Please find the numbers

Re: Bottom 5

varunreddy — Mon, 11 Jul 2016 17:21:45 GMT

Sunny,

You are right. I have 0 values for bottom 5

Thanks,

Varun Reddy

Re: Bottom 5

varunreddy — Tue, 12 Jul 2016 15:26:59 GMT

Hi Sunny,

Bottom 5 values are 0's. When I try to uncheck Suppress Zeros from presentation tab, I should see bottom 5 "Assessment Names". But it is showing error meaasge "No data to display".

Can you help me with this?

Thanks in advance!

Regards,

Varun

Re: Bottom 5

sunny_talwar — Tue, 12 Jul 2016 15:31:15 GMT

Would it be possible to share a sample to look at the issue?