topic Re: Individual Status in QlikView

Individual Status

Anonymous — Tue, 24 Nov 2015 03:51:08 GMT

Hi Experts,

I have student score card like this

Student ID	Maths
1	Pass
2	Fail
3	Pass
4	Pass
5	Pass
6	Pass
7	Fail
8	Pass
9	Fail
10	Pass

My required output is

Status	Count
Pass	7
Fail	3

Thank you in Advance!!

Re: Individual Status

arasantorule — Tue, 24 Nov 2015 04:03:47 GMT

Hi,

Please refer the attached.

Dimension : Maths

Expression: Count([Student ID])

Thanks.

Re: Individual Status

engishfaque — Tue, 24 Nov 2015 04:14:57 GMT

Dear Anil,

Kindly find attached file, I hope you are looking for that one.

Kind regards,

Ishfaque Ahmed

Re: Individual Status

tamilarasu — Tue, 24 Nov 2015 04:15:26 GMT

Check the attachment.

Data:

Load Distinct Maths,

Count([Student ID]) as Count

Group by Maths;

LOAD * INLINE [

Student ID, Maths

1, Pass

2, Fail

3, Pass

4, Pass

5, Pass

6, Pass

7, Fail

8, Pass

9, Fail

10, Pass

];

Re: Individual Status

senpradip007 — Tue, 24 Nov 2015 04:24:41 GMT

Have a look at this.

Re: Individual Status

Anonymous — Tue, 24 Nov 2015 04:25:29 GMT

Hi,

I am using personal edition, could you please paste the expression

Thank you,

Re: Individual Status

Anonymous — Tue, 24 Nov 2015 04:30:48 GMT

Hi,

I am using personal edition, could you please paste the expression

Thank You,

Re: Individual Status

tamilarasu — Tue, 24 Nov 2015 04:35:04 GMT

Or simply load the data and create a straight / pivot table. Maths field as dimension and Count([Student ID]) as expression.

Re: Individual Status

rajuamet — Tue, 24 Nov 2015 04:39:12 GMT

Status:

Load Maths as Status,

Count([Student ID]) as Count

Group by Maths;

LOAD * INLINE [

Student ID, Maths

1, Pass

2, Fail

3, Pass

4, Pass

5, Pass

6, Pass

7, Fail

8, Pass

9, Fail

10, Pass

];

Re: Individual Status

engishfaque — Tue, 24 Nov 2015 04:45:07 GMT

Dear Anil,

Here is data model and expression,

Data Model:

StudentGrades:

LOAD * Inline [

Student ID, Maths

1, Pass

2, Fail

3, Pass

4, Pass

5, Pass

6, Pass

7, Fail

8, Pass

9, Fail

10, Pass

];

Expression:

=Count ({<Maths = {'Pass'}>} [Student ID])

=Count ({<Maths = {'Fail'}>} [Student ID])

For more, please check attached screenshots.

Kind regards,

Ishfaque Ahmed

Re: Individual Status

senpradip007 — Tue, 24 Nov 2015 04:50:54 GMT

Data Model:

LOAD * INLINE [

Student ID, Maths

1, Pass

2, Fail

3, Pass

4, Pass

5, Pass

6, Pass

7, Fail

8, Pass

9, Fail

10, Pass

];

In straight chart,

Dimensions:

Maths

Expressions:

Count(Maths)

Re: Individual Status

jagan — Tue, 24 Nov 2015 04:56:13 GMT

Hi,

Try like this

Dimension: Maths

Expression: Count(StudentID)

Regards,

Jagan.

Re: Individual Status

jagan — Tue, 24 Nov 2015 04:57:12 GMT

Or you can also try with two expressions without dimension

Dimensions: ---

Expressions:

Pass:

=Count ({<Maths = {'Pass'}>} [Student ID])

Fail:

=Count ({<Maths = {'Fail'}>} [Student ID])

Hope this helps you.

Regards,

Jagan.

Re: Individual Status

Anonymous — Tue, 24 Nov 2015 05:22:42 GMT

How to show if i have

Student ID	Maths
1	Pass
2	Fail
3	Absent
4	Pass
5	Absent
6	Pass
7	Fail
8	Pass
9	Fail
10	Pass

I dont want to show 'Absent'

My Required Output is

Status	Count
Pass	5
Fail	3

Thank You,

Re: Individual Status

Mahamed_Qlik — Tue, 24 Nov 2015 05:24:41 GMT

Dear Anil,

Simply load the data using excel sheet or you can load the data by using inline load feature provided by qlikview

After loading data you can use the straight table object.

In straight table properties you can select

dimension as Maths

Expression as Count(Student ID)

The required output can be seen after reloading your application.

Have a good time....

Note : inline load can be done as follows :

Open the application script window.

Go to click on insert tab.

Select load statement from drop down.

Select Load Inline option..

Put your data as follows

LOAD * INLINE [

Student ID, Maths

1, Pass

2, Fail

3, Pass

4, Pass

5, Pass

6, Pass

7, Fail

8, Pass

9, Fail

10, Pass

];

OR you can directly open script window and type the data manually as above.

(But why to waste the valuable time if qlik view has auto inline option )

Re: Individual Status

jagan — Tue, 24 Nov 2015 05:31:46 GMT

Hi,

Try like this

Hi,

Try like this

Dimension: Maths

Expression: Count({<Maths-={'Absent'}>}StudentID)

Regards,

Jagan.

Re: Individual Status

jagan — Tue, 24 Nov 2015 05:32:52 GMT

Or you can also try with two expressions without dimension

Chart : Pivot Table

Dimensions: ---

Expressions:

Pass:

=Count ({<Maths = {'Pass'}>} [Student ID])

Fail:

=Count ({<Maths = {'Fail'}>} [Student ID])

Drag expression to left.

Hope this helps you.

Regards,

Jagan

Re: Individual Status

Mahamed_Qlik — Tue, 24 Nov 2015 05:33:28 GMT

Dear Anil,

For showing only Maths as 'Pass' and 'Fail'

you can use use calculated dimension as follows.

In dimension tab use calculated dimension only

after selection calulated dimention it will ask for an expression so write as below :

=if(Maths= 'Pass' or Maths='Fail', Maths)

and put the label name as Maths.

So the output will be shown for Maths as 'Pass' and 'Fail' only not Absent.

Have a good time ....

Re: Individual Status

nagarjuna_kotha — Tue, 24 Nov 2015 05:36:21 GMT

Hi Anil,

As per your requiremet and your data no need to do any calculations and any changes in your script..

Just load simply.

Follow below steps:

1.Take Straight Table

2. Dimension is Maths and change Label to Status.

3. Expression is Count(Student ) Label ids Count.

Regards,

Nagarjuna

Re: Individual Status

rajuamet — Tue, 24 Nov 2015 05:38:35 GMT

Status:

Load if(Wildmatch(Maths,'Pass','Fail'),Maths) as Status,

if(Wildmatch(Maths,'Pass','Fail'),Count([Student ID])) as Count

Group by Maths;

LOAD * INLINE [

Student ID, Maths

1, Pass

2, Fail

3, Absent

4, Pass

5, Absent

6, Pass

7, Fail

8, Pass

9, Fail

10, Pass

];