Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculating Min using Set Analysis

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



Labels (1)
2 Replies
Not applicable
Author

Try the following expression:

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

Not applicable
Author

Yes

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


BR

//ONDER

/*ALTINBILEK*/