Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

sum... problem

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??

Tags (1)
6 Replies
Not applicable

Re: sum... problem

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,

MT

sudeepkm
Valued Contributor III

Re: sum... problem

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.

amit_saini
Honored Contributor III

Re: sum... problem

Hi,

Please share your application.

Thanks,

AS

Not applicable

Re: sum... problem

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

sasikanth
Valued Contributor III

Re: sum... problem

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)

jebamalai
Valued Contributor

Re: sum... problem

I would go with FShanaghy

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

Community Browser