topic Re: Top 3 values from the table? in QlikView

Top 3 values from the table?

Kohli — Wed, 25 Nov 2020 16:16:04 GMT

I have table like

E.id, Basesalary

1, 1000

1, 2000

1, 3000

1, 5000

2, 2000

2, 3000

2, 4000

3,3000

3, 4000

4, 5000

4, 6000

Create a base salary table chart and highlight the top three with different colours. Use autogenerate number as id colum

vishsaggi — Thu, 19 Jul 2018 14:30:30 GMT

Add Straight table and add

Dim: E.id

Expr: = Max(BaseSalary)

then in expr background add

= Pick(Rank(max(Basesalary),4,1), LightGreen(), LightGray(), LightRed())

alis2063 — Thu, 19 Jul 2018 14:51:42 GMT

Expression:

IF(RANK(SUM(Amount))<4,SUM(Amount))

Background Expression:

IF(RANK(SUM(Amount))=1,rgb(255,0,0),

IF(RANK(SUM(Amount))=2,rgb(128,255,0),

IF(RANK(SUM(Amount))=3,rgb(0,255,255))))

Kohli — Thu, 19 Jul 2018 15:11:12 GMT

Iam using QlikSense

vishsaggi — Thu, 19 Jul 2018 15:20:30 GMT

Did you try the expr i sent in your Qliksense? You want to display only top 3 in your table?

If yes, try calculated dimension like:

For your E.id dimension write the below

= Aggr(IF(Rank(Max(Basesalary),4,1)<4, E.id), E.id)

Kohli — Sat, 21 Jul 2018 05:05:56 GMT

yes, iam getting. But i want different colours.