topic Re: Create Chart in QlikView

Create Chart

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

I need help in creating three charts. Selecting a employee name in the “employee name” list box, one chart must show their annual sales compared to the annual average sales of employees in their same position (Employee_Pto field)

Another chart shows must show selected employee annual sales compared to the annual average sales of employees in the others position (Employee_Pto field)

Last chart must show selected employee annual sales compared to the average sales of employees in their same department (for example, if I select employee 36, must show their annual sales compared to the annual average sales of employees in 5000 to 5210 department_id

I’ve attached a data model.

Any help would be appreciated

Thanks

Re: Create Chart

eva_maria — Tue, 17 Jul 2018 19:14:41 GMT

Hi!!

On main sheet, i have a chart (salesman-avg all pto). How do I show the avg sales of all Pto excluding the position (pto) of the selected employee??

On sheet1, level 1 chart I want to show by year, the avg sales for each one of the levels but it shows the same value for each level.

Thanks for the help.

Regards

Re: Create Chart

ogautier62 — Wed, 18 Jul 2018 07:02:36 GMT

Hi,

try this :

assume Year is selected or is in dimension :

(sum({1<Employee_Pto = P({$}) >} Sales) - sum(Sales) ) / (count({1<Employee_Pto = P({$}) >} Emplye_ID) -1)

ie : sum of sales all salaries in same position - sum sales of selected salary

divide by count of salary same posityion minus 1

(replace with your field I didn't load qvw

regards

Re: Create Chart

eva_maria — Wed, 18 Jul 2018 10:51:14 GMT

Hi Olivier!!

Thanks for your reply.

I`ve used yoru expresion in my main sheet chart (salesman-avg all pto) an the result is "allocated memory exceeded"

Regards

Re: Create Chart

ogautier62 — Wed, 18 Jul 2018 12:12:42 GMT

what are your dimensions ?

in a shart it take account of dimension but it could be necessary to add total <Employee_tpo> somewhere.

and could you share some datas

Re: Create Chart

eva_maria — Wed, 18 Jul 2018 12:32:29 GMT

On my sheet 1 chart (Level 1) my dimensions are Year and Level 1.

On main sheet chart (salesman-avg all pto) dimension is Year.

I think all data is in attached file in my second post.

thanks!!

Re: Create Chart

ogautier62 — Wed, 18 Jul 2018 12:43:13 GMT

I have a free version, can't upload qvw

select an employe, year and try expression in list box to begin,

and in text th load inline if you have