topic Re: sum... problem in QlikView

sum... problem

Tue, 27 May 2014 09:51:37 GMT

Hi !!

I want to create a pivot table that shows the total of the salaries for job. like dimension i choose "job" and i use the expression "Sum(Salaries)" , but i obtain the same salary value for each "job"...so i think that i made a mistake in the expression...so someone can tell me the correct string that i have to use??

Re: sum... problem

Tue, 27 May 2014 09:53:12 GMT

Hi you problem sounds more like a datamodell issue. mybe if you give me some sample data i will be able to help you

regards,

Re: sum... problem

sudeepkm — Tue, 27 May 2014 10:00:28 GMT

do you have the fields Job and Salary in same table?

I think it is better to check the data first.

If possible pls post a sample qvw with data.

Re: sum... problem

amit_saini — Tue, 27 May 2014 10:00:40 GMT

Hi,

Please share your application.

Thanks,

Re: sum... problem

Tue, 27 May 2014 10:08:52 GMT

It sounds like either your dimension or fact is not joined properly or you are performing an inaccurate join which is causing the issue.

I would start by validating the data model

Re: sum... problem

sasikanth — Tue, 27 May 2014 10:12:40 GMT

HI GABRIELE

Here the Problem is JOB filed don`t have repeated values means jobs,

Thats y it is showing same value for every job

But u will get the sum at the END ,

In Table charts if the JOB value is repeating then U will caluculate the sum by using GROUP BY Job filed. using AGGR function like

Aggr(sum(salary),job)

Re: sum... problem

Anonymous — Tue, 27 May 2014 10:24:47 GMT

I would go with FShanaghy

Because I had a same issue which I have rectified via the data model.