topic Re: straight table query in total sum in QlikView

straight table query in total sum

Tue, 23 Sep 2014 16:04:57 GMT

hi all,

while selecting top 10 in straight table, the Expression total is showing complete total rather than top 10 total. how to resolve this?

table structure is simple 1 column as client name and 2 nd column as revenue $ value

please advise

thanks

sukhwant

Re: straight table query in total sum

ecolomer — Tue, 23 Sep 2014 16:08:28 GMT

An example to see ....

Re: straight table query in total sum

Anonymous — Tue, 23 Sep 2014 16:09:01 GMT

Hello Sukhwant,

Do You have some image or sample data ?

Morandi

Re: straight table query in total sum

Tue, 23 Sep 2014 16:11:18 GMT

sorry no developer license, so can't open attachment

Re: straight table query in total sum

maxgro — Tue, 23 Sep 2014 16:14:26 GMT

are you using dimension limit for top?

Re: straight table query in total sum

Tue, 23 Sep 2014 16:14:32 GMT

hi ,

data can be

Client name value

1 50

2 40

3 30

4 20

5 10

6 50

so when i say top 5 in presentation tab, and expression of value as "sum of rows", i should get total as 150, but i am getting 200

please advise

thanks

Re: straight table query in total sum

maxgro — Tue, 23 Sep 2014 16:16:18 GMT

different ways to get top

Show Top Performers | Qlik Community

Re: straight table query in total sum

Tue, 23 Sep 2014 16:17:05 GMT

Properties - presentation - max num (1-100) - 5

Re: straight table query in total sum

jyothish8807 — Tue, 23 Sep 2014 16:24:37 GMT

Hi,

Try

sum(aggr(rank(revenue)<=5,revenue))

Regards

Re: straight table query in total sum

anbu1984 — Tue, 23 Sep 2014 16:42:22 GMT

Use calculated dimension to restrict number of dimensions which will give you correct total

=If(Aggr(Rank(Sum(value)) <= 5,[Client name]),[Client name])

Re: straight table query in total sum

Tue, 23 Sep 2014 17:33:52 GMT

Hi Sukhwant, Where you are using Client_Name in dimension use the calculated dimension as shown below: if (aggr(Rank((sum(Revenue),0,1)[client_name])<=10,[clinet_name])

Re: straight table query in total sum

ecolomer — Wed, 24 Sep 2014 05:07:34 GMT

See this

=if(aggr((Rank(SUM(Sales),0,1)),[Branch Code],[Sales Operator])<= 5, [Branch Code])