topic Re: No matching in QlikView

No matching

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

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?

Re: No matching

manoj217 — Mon, 22 Oct 2018 10:44:08 GMT

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

Re: No matching

jyothish8807 — Mon, 22 Oct 2018 10:54:09 GMT

Hi Sony,

Replace your total expression by this:

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

Br,

Re: No matching

soniasweety — Mon, 22 Oct 2018 10:55:24 GMT

thanks i will check and update in 5min

Re: No matching

manoj217 — Mon, 22 Oct 2018 11:14:25 GMT

Re: No matching

soniasweety — Mon, 22 Oct 2018 11:14:42 GMT

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

Re: No matching

soniasweety — Mon, 22 Oct 2018 11:15:28 GMT

can you atatch the application?

Re: No matching

soniasweety — Mon, 22 Oct 2018 11:35:17 GMT

manoj217

Re: No matching

manoj217 — Mon, 22 Oct 2018 11:58:57 GMT

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

Re: No matching

jyothish8807 — Mon, 22 Oct 2018 12:08:13 GMT

Hi Sony,

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

Br,

Re: No matching

soniasweety — Tue, 23 Oct 2018 10:01:33 GMT

any help on this?

Frank Hartmann

Re: No matching

manoj217 — Tue, 23 Oct 2018 10:22:30 GMT

Please share your result will do the analysis

Re: No matching

soniasweety — Tue, 23 Oct 2018 11:24:28 GMT

attaching the live issue... when open the dashboard. you can see two tables one is top5 and one is total details

Sunny Talwar

manoj kumar

now compare two tables top5 values... for below seelctions

Region-asiapacific and accountname- minestery of education ... the list table having two values but top5 table is showing the lowest value only

Re: No matching

sunny_talwar — Tue, 23 Oct 2018 11:34:13 GMT

soniasweety‌ -

I am not entirely sure which of the two tables in your app we are trying to fix? I see two tables: 1) ser, 2) Opportunities List. Also, what exactly are you looking to get to?

Re: No matching

soniasweety — Tue, 23 Oct 2018 11:37:09 GMT

hi Sunny Talwar chk this app

Re: No matching

sunny_talwar — Tue, 23 Oct 2018 11:37:30 GMT

May be try this

=If(Aggr(Rank(Sum(Value), 4), Account_Region, [Account_Name], opportunity_identifier)<=5, Sum({<SERVICE_TYPE={'Service',Hardware}>} Value))

Re: No matching

soniasweety — Tue, 23 Oct 2018 12:34:31 GMT

can you help on this

Gysbert Wassenaar

i want to show top5 values for each region ... it means in top5 table it should show 15 rows of data. it should match with the list table top 5 rows data in attached app

Re: No matching

sunny_talwar — Tue, 23 Oct 2018 14:30:17 GMT

Try this

=IF(Aggr(NODISTINCT Rank(SUM(Value),4),Account_Region,[Account_Name])<=5, SUM({<SERVICE_TYPE={'Service'}>}Value))

Re: No matching

soniasweety — Tue, 23 Oct 2018 14:41:50 GMT

almost near... one more thing to be chnaged like... in customername column customers are repeting.

it should show distinct customer max value only

i have higiligted in image should not show in list like for all

Re: No matching

sunny_talwar — Tue, 23 Oct 2018 14:49:48 GMT

There are three expression.... based on which expression you want to choose the max?