topic Calculating Min using Set Analysis in QlikView

Calculating Min using Set Analysis

Tue, 17 Aug 2010 07:44:33 GMT

Hi All,

I want to calucate the following

Min(if(GPA>0,GPA)) using set analysis but I want to exclude from the selections Country & State .

So i have written the expression in the following manner

if(GPA>0,Min({$<GPA_Country,[GPA State]=>}GPA)) but its not working .

Please help ................

Your help is greately appreciated .

Thanks in Avance

Tue, 17 Aug 2010 07:52:53 GMT

Try the following expression:

if(GPA>0,Min({$<GPA_Country=,[GPA State]=>}GPA))

Tue, 17 Aug 2010 09:13:37 GMT

Min({$<GPA={">0"},GPA_Country=,[GPA State]=>}GPA))

//ONDER

/*ALTINBILEK*/