Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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)
Hi,
Try like this
Dimension: Maths
Expression: Count(StudentID)
Regards,
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.
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,
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 )
Hi,
Try like this
Hi,
Try like this
Dimension: Maths
Expression: Count({<Maths-={'Absent'}>}StudentID)
Regards,
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
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 ....
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
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
];