topic Re: stright table in QlikView

stright table

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

Hi All,

i want to top 10 customers in stright table [not through dimension limit tab]

thanks

sony

simospa — Fri, 31 Aug 2018 12:52:43 GMT

Hi Sony,

1. what are you asking? I cannot understand...

2. ok, but why you don't want to use the dimension limit?

Simone

soniasweety — Fri, 31 Aug 2018 12:54:01 GMT

i want to dispaly top 10 customers in the table

if i use dimension limit tab it is not giving exact 10 bcz i have 3measures

i think that is the reason

so how can i achieve this?

Anil_Babu_Samineni — Fri, 31 Aug 2018 13:09:37 GMT

Try this?

Measure1:

Sum({<[Type]={'Hw'},[Name]=$::[Name], Customer={"=Rank(SUM(Amount))<=10"}>}[Amount])/$(vFormat)

Measure2:

Sum({<[Type]={'Sr'},[Name]=$::[Name], Customer={"=Rank(SUM(Amount))<=10"}>}[Amount])/$(vFormat)

Measure3:

Sum({<[ Name]=$::[ Name], Customer={"=Rank(SUM(Amount))<=10"}>}[Amount])/$(vFormat)

ogautier62 — Fri, 31 Aug 2018 13:26:34 GMT

Hi,

Sony,

do you want top 10 total sales and then the 3 measures (if so Anil's solution)

or do you want for each selection top 10 in it ?

regards

soniasweety — Fri, 31 Aug 2018 15:24:21 GMT

thanks sir it worked.