topic Re: Which chart item suits best? in QlikView

Which chart item suits best?

Mon, 17 Feb 2014 12:46:41 GMT

Hi,

I have ID and Companynames. Companyname is dimension and the expression is

Sum(Aggr(Count(Distinct(IF(NOT ISNULL(Companyname), ID))),IssueID))+Sum(Aggr(Count(Distinct(IF(ISNULL(Companyname), ID))),ID))

I already have straight table. I would need to show this information in chart. can anyone suggest me which is the best chart to create this?

Thanks.

Re: Which chart item suits best?

Mon, 17 Feb 2014 12:54:29 GMT

Quick question, the 2nd part of your aggr states what to do if is null. Since company name is your dimension and you counting ID when company name is null, is this not rendering your chart redundant since you are unable to drill down into those null values?

Secondly, if IssueID and ID essentially refer to the same thing, just a different key, would a stacked bar chart where you split your expression into two separate expressions be your best bet?

Re: Which chart item suits best?

Mon, 17 Feb 2014 13:00:50 GMT

Sorry the expression is Sum(Aggr(Count(Distinct(IF(NOT ISNULL(Companyname), ID))),ID))+Sum(Aggr(Count(Distinct(IF(ISNULL(Cmpanyname), ID))),ID))

Re: Which chart item suits best?

Mon, 17 Feb 2014 13:29:34 GMT

Still confused what you are trying to achieve by using company as a dimension but referring to in your expression when that value is null count ID. Would this not populate that same sum across all company values?

Re: Which chart item suits best?

Mon, 17 Feb 2014 13:50:02 GMT

Actually I have the below in table

Dimension: Companyname
Expression 1 : Sum(Aggr(Count(Distinct(IF(NOT ISNULL(Companyname), ID))),ID))+Sum(Aggr(Count(Distinct(IF(ISNULL(Cmpanyname), ID))),ID))

Expression 2 : Sum(DISTINCT(Wages))