topic Bar Chart in QlikView

Bar Chart

Mon, 15 Jun 2009 11:51:52 GMT

Hi,

I have a weird requirement. I have a chart with a cyclic group of 'Employee' and ''Designation'. I have Sales1 and Sales2 in the expression. My requirement is like, when I cycle through Employees, I should get Sales1 and sales2 in the bar chart and When I cycle it through Designation, I should see only Sales2. Is this Possible? To be more clearer, Please look at the attachment.

Bar Chart

Mon, 15 Jun 2009 12:32:28 GMT

Hi,

This can be achieved, when you have your dimension as drill down.

I doubt , this can be achieved r not,

May be some one can help you.

- Sridhar

Bar Chart

Mon, 15 Jun 2009 14:13:20 GMT

Hi,

Just write the following expression in your Sales1 and it will work according to your requirement..

if (count(Designation)=1,Sum(Sales1),0)

regars..

Afzal

Bar Chart

Wed, 17 Jun 2009 18:46:45 GMT

Hi,

Thanks for the suggestion. But, still I am not able to implement your logic in my application. See the attachment.

I have a field Des1 in the table T2 only. I need to include a spinner which has two fields (Name1 from T3 table and Des1 from T2 table). So, when i spin through Name1, the result is correct, But when I spin through Des1, the result is not correct as it takes value for T1 also, which does not have a value for Des1. Please look at the attachment.

Is it possible to achieve my requirement in the front end (expression) rather than altering the script.

Bar Chart

Wed, 17 Jun 2009 23:18:15 GMT

I tried with this

(count(Designation)=1,Sum(Sales1),0) .It's wokring but you need to figues how to change the legend accordingly