topic Re: how to display 2 expressions in QlikView

how to display 2 expressions

Tue, 22 Jan 2013 06:22:06 GMT

I want to display my attendance and non-attendance data in 1 bar graph per month.

This is the data:

Attendend or Not July 2012 Aug 2012 Sept 2012Attendance 1000 1500 2500non-attendance 200 150 300
Now I am only able to display the attendance in 1 graph and the non attendance in another graph as the expression says error when I try to do SUM (attendance) SUM (non-attendance).
Can anyone assist with this? - Thanks

Attended or Not	July	August	September
Non-Attendance	4960	5944	4347
Attendance	21759	27846	11711

Re: how to display 2 expressions

er_mohit — Tue, 22 Jan 2013 06:39:19 GMT

see the attached file

Re: how to display 2 expressions

Tue, 22 Jan 2013 06:39:27 GMT

use 2 expr

1st expr

if(

Attended

or Not

='Attendance',sum(july)+sum(august)+sum(september),Null())

2nd exp

if(

Attended

or Not

='Non-Attendance',sum(july)+sum(august)+sum(september),Null())

Re: how to display 2 expressions

Tue, 22 Jan 2013 06:48:04 GMT

Thanks, however I cannot open the file as I am using the personal edition. Please can you send me the expression

Re: how to display 2 expressions

Tue, 22 Jan 2013 06:48:42 GMT

Thanks, but it says "Bad expression"

Re: how to display 2 expressions

Tue, 22 Jan 2013 06:52:00 GMT

can u give ur expressions

im using some sample data its work

plz see that image

it display empno=1 sum in one bar and 2 in another bar same like ur

ateendend, not-attend

Re: how to display 2 expressions

Tue, 22 Jan 2013 07:00:10 GMT

I think it does not find Attendance and Non-Attendance

Re: how to display 2 expressions

Tue, 22 Jan 2013 07:10:26 GMT

Thanks, I have sorted it out.