Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
So i need to do the following analysis in Qlikview-->
Find the number of students by Age who don't hold distinction.
My straight table should show # Students by age who don't have Distinction Marks as well Distinction Grade.
Dimensions available:
a) Student ID
b) Student Age
Metrics Available:
a) Practical Marks
b) Theory Marks
I was trying to use the Following -->
Dimension as Student Age
and Expression as
=Sum(AGGR(IF(sum(Practical Marks)<70 and Sum(Theory Marks)<70,1,0),Student ID))
But this not returning me any values.
Any thought ?
Dear Shalaka
Find expression AGGR with IF used you can modify as per your requirement
fabs(SUM(AGGR(if(((vSelectDate - max({$<StockInOutIndicator={1}>}PostingDate) >=271)),SUM(Inv_Val)),Location_Code, Item_Code, [Lot No_]))/100000)
You can put multiple if required,
Vikas
Try like:
=Sum(AGGR(IF(sum([Practical Marks])<70 and Sum([Theory Marks])<70,1,0),[Student Age],[Student ID]))
Hi,
Use Age as Dimension and use the below expression
=Sum(AGGR(IF(Sum([Practical Marks])<70 AND Sum([Theory Marks]) <70, 1, 0), [Student ID]))
Hope this helps you.
Regards,
Jagan.