topic Re: How to write the Expression in QlikView

How to write the Expression

kunkumnaveen — Fri, 04 Jun 2021 05:24:45 GMT

Hello All,

I am trying to show case top 4 value in a pivot table, the below expression I have used is working partially

Expression : if(Rank(total Sum(Sales),4,1)<=4,sum(Sales))

Output:

I am having two issues over here

1) I am showcasing the top4 values hence it should show only those rows not the Null/Blank rows

2) After getting top4 I need showcase them in Descending order

How can I achieve the above two requirements

Thanks

Re: How to write the Expression

kunkumnaveen — Fri, 04 Jun 2021 11:56:01 GMT

Any suggestion on the above issue will be helpful

Re: How to write the Expression

HirisH_V7 — Sat, 05 Jun 2021 17:47:37 GMT

- Data Handling and nulls can be removed.

- Then sort it accordingly.

Re: How to write the Expression

Vikash — Sun, 06 Jun 2021 03:37:00 GMT

Hi,

1. To remove the null/Missing Values check below-

=if(rank(sum(Sales))<=4, sum(Sales)) add this as expression

=aggr(if(rank(sum(Sales))<=4,GUID),GUID) add this as calculated dimension

2. for sorting of these values in a Pivot table you need to add the sorting expression under the sort tab as per your requirement like- =if(rank(sum(Sales))<=4, sum(Sales))

Else you can use straight table and make the sorting on the expression.