Individual Status

[Anonymous]

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!!

[senpradip007]

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)

[jagan]

Hi,

Try like this

Dimension: Maths

Expression: Count(StudentID)

Regards,

Jagan.

[jagan]

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.

[Anonymous]

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,

[Mahamed_Qlik]

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 )

[jagan · Accepted solution]

Hi,

Try like this

Hi,

Try like this

Dimension: Maths

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

Regards,

Jagan.

[jagan]

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

[Mahamed_Qlik]

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 ....

[nagarjuna_kotha]

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

[raju_insights]

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

];