topic Re: help on data in QlikView

help on data

manoranjan_d — Thu, 02 Apr 2015 09:00:51 GMT

Hi below is my data.

Gender students	Present students	Absent students
Male	9	0
Female	0	10

Now i want my table one more field as total students count so i want the total present and absent put in one field as Total students. kindly help me on the coding.please

Gender	Present	Absent	Total students
Male	9	0	9
Female	0	10	10

Re: help on data

Anonymous — Thu, 02 Apr 2015 09:06:46 GMT

Does this point you in the right direction ?

load

[Present students] + [Absent students] as [Total students],

;

LOAD [Gender students],

[Present students],

[Absent students]

FROM

[https://community.qlik.com/thread/158606]

(html, codepage is 1252, embedded labels, table is @1);

Re: help on data

sunny_talwar — Thu, 02 Apr 2015 09:08:29 GMT

Try this:

Table:

LOAD Gender students,

Present students as Present,

Absent students as Absent,

(Present students + Absent students) as Total students

FROM xyz;

HTH

Best,

Sunny

Re: help on data

manoranjan_d — Thu, 02 Apr 2015 09:09:34 GMT

if i try this i will get output as

Total students

19.

so the above output will be mixed of both male and female.

i need separate data for both male and femal

Total students

Re: help on data

manoranjan_d — Thu, 02 Apr 2015 09:10:46 GMT

if i try this i will get output as

Total students

19.

so the above output will be mixed of both male and female.

i need separate data for both male and femal

Total students

Re: help on data

Anonymous — Thu, 02 Apr 2015 09:11:17 GMT

Look at attached qvw, Male & Female are seperate :

Re: help on data

sunny_talwar — Thu, 02 Apr 2015 09:12:16 GMT

That is not true. In the front end, if you create a chart with Gender students as your dimension and Sum(Total students) as your expression you will see this:

Gender students Total Students

Male 9

Female 10

Best,

Sunny

Re: help on data

anbu1984 — Thu, 02 Apr 2015 09:12:35 GMT

Tbl:
LOAD * Inline [
Gender students,Present students,Absent students
Male,9,0
Female,0,10 ];


Join(Tbl)
Load Sum([Present students]) As Prsnt, Sum([Absent students]) As Absnt Resident Tbl;


Final:


Load *,If(Gender='Male',Prsnt,Absnt) As Total Resident Tbl;


Drop Table Tbl;

Re: help on data

buzzy996 — Thu, 02 Apr 2015 11:21:15 GMT

1. u can simply load ur data through script

2. in straight/pivot table u can create one expression as sum(Present students)+sum(Absent students) and lable as Total

Re: help on data

Thu, 02 Apr 2015 11:56:23 GMT

Hi,

You can see attached qvd.

Re: help on data

Thu, 02 Apr 2015 11:59:25 GMT

Hi,

You can check another one.

Re: help on data

praveenak — Thu, 02 Apr 2015 13:22:21 GMT

Hi,

Please find below script

students:

LOAD * INLINE [

Gender students, Present students, Absent students

Male, 9, 2

Female, 1, 10

];

TotStudents:

LOAD

([Present students] + [Absent students]) as [Total students]

Resident students;

Hope this helps you.