topic Re: Re: Sorting Issue in chart in QlikView

Sorting Issue in chart

Thu, 05 Jun 2014 07:30:09 GMT

Hi QV,

In the above mentioned straight tables, I'm able to get the top 10 accounts in the first table, and its working fine.

But the problem is with the second table i.e. bottom 10 accounts.

In this chart when I apply Dimension limits i'm not able to get the required result, its giving me blank means 0 records.

Please help me on this....

Thanks & Regards,

Ananth

Thu, 05 Jun 2014 07:49:12 GMT

Maybe your bottom ten accounts has result = 0 or null? Check it.

Thu, 05 Jun 2014 08:13:38 GMT

I already checked, but non of them dont have 0 results.

Thu, 05 Jun 2014 08:21:33 GMT

Please attach sample.

regards

Darek

Thu, 05 Jun 2014 08:41:29 GMT

Hi Darius,

Here i'm attaching qvw and excel with sample data.

Please get bottom 10 results in the chart.

thanks & Regards,

Ananth

Thu, 05 Jun 2014 08:51:34 GMT

Thu, 05 Jun 2014 08:52:35 GMT

Thu, 05 Jun 2014 08:58:46 GMT

Thank you so soooo much Darius.

The issue come at Suppress-zero values and suppress missing.

You solved my problem, Thanks for your valuable time provided for me.

Regards,

Ananth