topic Re: Report format issue in QlikView

Report format issue

qlikviewwizard — Sun, 31 May 2015 05:34:27 GMT

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

Re: Report format issue

Sun, 31 May 2015 06:45:45 GMT

Hi,

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

Please find solution in attached QVW file.

Regards,

Uday.

Re: Report format issue

MarcoWedel — Sun, 31 May 2015 19:40:52 GMT

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

Re: Report format issue

pratap6699 — Sun, 31 May 2015 20:45:19 GMT

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

Re: Report format issue

qlikviewwizard — Wed, 03 Jun 2015 01:57:13 GMT

Hi MarcoWedel,

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

Re: Report format issue

jagan — Thu, 04 Jun 2015 07:13:59 GMT

Hi,

Check this link

Showing two measures with the filter selection

Re: Report format issue

Thu, 04 Jun 2015 07:42:24 GMT

Hi,

The solution to the above question is attached below.

Thanks & Regards.