Report format issue

[qlikviewwizard]

Hi All,

I want to show for each EmpNo data in one row. But it is showing other value in two rows.

Please help me on this.

EmpNo	Department	Job	Ename	Sal
EmpNo1	Accounting	Job	Ename1	88613.7402
EmpNo1	-	-	-	7987263.336
EmpNo2	Accounting	Job1	Ename2	2284687.758
EmpNo2	-	-	-	5690275.578
EmpNo3	Accounting	Job2	Ename3	1049730.867
EmpNo4	Accounting	Job3	Ename4	2888898.526
EmpNo5	Accounting	Job4	Ename5	1618679.615
EmpNo6	Accounting	Job5	Ename6	96066.57

[#2]

Hi,

Use aggr(sum(Sal),EmpNo) in expression.

Please find solution in attached QVW file.

Regards,

Uday.

[MarcoWedel]

Hi,

another solution could be to let the '-' values be null-values (if not already so) and include the Department, Job and Ename fields as expressions rather than dimensions in the straight table.

The expression for 'Sal' then would be simply:

=Sum(Sal)

SET NULLINTERPRET='-';

table1:
LOAD * INLINE [
    EmpNo, Department, Job, Ename, Sal
    EmpNo1, Accounting, Job, Ename1, 88613.7402
    EmpNo1, -, -, -, 7987263.336
    EmpNo2, Accounting, Job1, Ename2, 2284687.758
    EmpNo2, -, -, -, 5690275.578
    EmpNo3, Accounting, Job2, Ename3, 1049730.867
    EmpNo4, Accounting, Job3, Ename4, 2888898.526
    EmpNo5, Accounting, Job4, Ename5, 1618679.615
    EmpNo6, Accounting, Job5, Ename6, 96066.57
];

hope this helps

regards

Marco

[pratap6699]

use =aggr(sum(Sal),EmpNo) in expression.it is used like a group by function so both employee ID's should caliculate and display in one row

[qlikviewwizard]

Hi MarcoWedel,

I have tried your solution. But Sal and Comm values are changing based on the selection of the Quarter filters.

[jagan · Accepted solution]

Hi,

Check this link

Showing two measures with the filter selection

[#7]

Hi,

The solution to the above question is attached below.

Thanks & Regards.