topic issue on Pivot table in QlikView

issue on Pivot table

Wed, 25 Nov 2020 16:16:04 GMT

Hi friends

i have a field called Rank based on this field i need to display top 10 Ranks in Pivot Table.i have only one number field i.e Rank field .so how write expression for This and how to create pivot table and how to filter it for Top-10 values

Rank fields having

1)'NUll'

2)0

3)1

4)2

5)222

6)523

like that ...Null means which is directly coming from database

Thanks

Re: issue on Pivot table

Saravanan_Desingh — Tue, 08 Mar 2016 00:41:26 GMT

I tried with few assumptions. Please check.

NULL was considered as String here

Not sure, how you want the Pivot table with single Field. I assumed the expression as Rank(Rank).

Let me know if you need something different.

Re: issue on Pivot table

Tue, 08 Mar 2016 16:53:25 GMT

if i apply rank(rank) i am getting only1 for complete table and i have few more fields among that ineed to filter the data based on Rank(Number field)field using pivot table.

Thanks

Re: issue on Pivot table

Saravanan_Desingh — Thu, 10 Mar 2016 00:50:28 GMT

Hi,

I still could not understand your requirements. I assume, you are struggling with Rank function, along with few more fields.

I have changed my example with two fields.

If you could post your App and explain with an example, it would help me to understand you issue.