topic How to get Distinct Values in Chart in QlikView

How to get Distinct Values in Chart

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

Hi,

Can Some one help me with my Question below

I have Multiple Rows in table Box like below

ProjectID [Total Service Credit Balance in Hours] as Field Names

Project 1-- 280 Hours

project 1 -280 hours

Project 1--280 Hours

Project 2--156 Hours

Project 2 --156 Hours

Project 2--156 Hours

I want to value of both projects as 436 so i tried to write like below

=(AGGR(SUM(DISTINCT [Total Service Credit Balance in Hours]),[Project ID])) in Chart Properties expressions.

But it works when i select for single project ID in filters , and if i remove filter i am not getting any values in my Chart expressions.

Can some one help me here , Please Thanks.

Best Regards,

Re: How to get Distinct Values in Chart

Anonymous — Wed, 22 Mar 2017 21:15:37 GMT

May be Aggr inside sum. Like this?

SUM(AGGR([Total Service Credit Balance in Hours],[Project ID]))

Re: How to get Distinct Values in Chart

marcus_sommer — Thu, 23 Mar 2017 08:26:46 GMT

I think that you have an issue with the data-quality and you should solve them first before trying to bypass them with complex expressions. In your case seems a data-cleaning within the script like this:

upper(trim(replace([Project ID], '--', '-'))) as [Project ID]

or maybe a mapping-solution for this suitable: Mapping … and not the geographical kind.

- Marcus

Re: How to get Distinct Values in Chart

sasiparupudi1 — Sat, 25 Mar 2017 17:58:09 GMT

Works Fine for me?

As Marcus says, may be you have data quality issues in your Data Model? Pl share a sample so that we can better understand your problem?