Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
soniasweety
Valued Contributor III

No matching

Hi All

Anil Samineni

Jyothish KC

franky_h79

im calcualting the top5 customers by region wisse in one table

other table i have detailed info

but if i select region i can t see the matching numbers for top5

how to fix it?

and one more -   in  Production  top5 table is taking lower value

means i have ID column so for perticular account two id;s are there  in that lowest values is showing in top5 table.  how to show the max value only in this case?

Tags (2)
1 Solution

Accepted Solutions

Re: No matching

Here, try this

=IF(Aggr(NODISTINCT Rank(SUM(Value),4),Account_Region,[Account_Name]) <= 5 and

Max(TOTAL <Account_Region, Account_Name> Aggr(IF(Aggr(NODISTINCT Rank(Sum(Value),4),Account_Region,[Account_Name])<=5, Sum({<SERVICE_TYPE={'Service',Hardware'}>}Value)),Account_Region,[Account_Name], Sales_Stage)) = Sum({<SERVICE_TYPE={'Service',Hardware'}>}Value),

Sum({<SERVICE_TYPE={'Service',Hardware'}>}Value))

23 Replies
manoj217
Contributor III

Re: No matching

You are saying your tables is not matching the sum of values right?

may i knw why r u using expression for top 5 directly you can use dimension limits it will show s on ly top5 customers

jyothish8807
Honored Contributor II

Re: No matching

Hi Sony,

Replace your total expression by this:

=If(Aggr(Rank(Sum(Value)),Region,Account_Name)<7,SUM({<SERVICE_TYPE={'Hardware','Service'}>}Value))

Br,

KC

Best Regards,
KC
soniasweety
Valued Contributor III

Re: No matching

thanks  i will check and update in 5min

manoj217
Contributor III

Re: No matching

Capture.JPG

soniasweety
Valued Contributor III

Re: No matching

jyothish8807

No stil i can see same issue    it is showing 5 value as 0  but i have max value for that is  80  its top3 values but im getting 0

its taking  low values  instead of max values in the top5 table.  how to get only max value

table1.PNGtable2-top5.PNG

soniasweety
Valued Contributor III

Re: No matching

can you atatch the application?

soniasweety
Valued Contributor III

Re: No matching

manoj217
Contributor III

Re: No matching

Capture.JPG

=IF(Aggr(Rank(SUM(Value),4),Region,Account_Name)<=5,SUM({<SERVICE_TYPE={'Service'}>}Value))

jyothish8807
Honored Contributor II

Re: No matching

Hi Sony,

What are the dimensions you are using. Can share the screenshot of the complete table ?

Br,

KC

Best Regards,
KC