Aggr Function with multiple IF statements - Qlik Community

Report Inappropriate Content · ‎2013-09-30

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 ?

vikasmahajan · ‎2013-10-01

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

tresesco · ‎2013-10-01

Try like:

=Sum(AGGR(IF(sum([Practical Marks])<70 and Sum([Theory Marks])<70,1,0),[Student Age],[Student ID]))

jagan · ‎2013-10-01

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.