topic Re: Straight table showing incorrect values in QlikView

Straight table showing incorrect values

Fri, 11 Oct 2013 14:10:47 GMT

Hi,

I need to show sum(salary) for each employee based on dates in straight table.. I used employee in dimension and in expression I used Sum(Salary).

It's showing incorrect values.

Could anyone help me how to write the correct expression to get values.

Thanks.

Re: Straight table showing incorrect values

jchoucq — Fri, 11 Oct 2013 14:15:44 GMT

Hi,

the expression you wrote seems ok.

Maybe, in you source, you have many data for the same employee on differents months.

Do you have a Year or a month field in your data model ?

johann

Re: Straight table showing incorrect values

srchilukoori — Fri, 11 Oct 2013 14:20:38 GMT

Are you trying to calculate the salary based on both employee and date? if so you need to add both date & employee to the dimensions.

Re: Straight table showing incorrect values

mdmukramali — Fri, 11 Oct 2013 14:21:27 GMT

Dear ,

can you share the sample apps.

Thanks,

Mukram.

Re: Straight table showing incorrect values

Fri, 11 Oct 2013 14:35:40 GMT

Thanks and can I know how to write expression in dimension to get last month amount

Re: Straight table showing incorrect values

Clever_Anjos — Fri, 11 Oct 2013 14:35:51 GMT

If you need to show "based on dates " shouldn´t you add "Date" as a dimension?

Re: Straight table showing incorrect values

Fri, 11 Oct 2013 14:44:27 GMT

Hi,

I need to show last month salary ,current month salary and To date salary. Is it possible to get these figures?

Thanks.

Re: Straight table showing incorrect values

Clever_Anjos — Fri, 11 Oct 2013 14:46:43 GMT

Yes, its possible, just playing around with Set Analysis

CurrentMonth = sum({<yourdatefield={">$(=monthstart(today())"}>}Salary) and so on...

Re: Straight table showing incorrect values

Fri, 11 Oct 2013 15:18:21 GMT

Thanks and with the same values when I am trying to create chart, and when I am selecting fiscalyear 2013-2014 it is showing negative(minus) values on Y-axis. can you let me know do I need to change anything in axes?