topic Re: Aggr Function with multiple IF statements in QlikView

Aggr Function with multiple IF statements

Mon, 30 Sep 2013 09:07:21 GMT

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 — Tue, 01 Oct 2013 11:44:51 GMT

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

tresB — Tue, 01 Oct 2013 11:51:59 GMT

Try like:

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

jagan — Tue, 01 Oct 2013 12:04:08 GMT

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.