topic Re: Using an if-statement in QlikView

Using an if-statement

shahamel — Mon, 05 Mar 2012 14:35:02 GMT

Dear users,

I have a small problem. I want to see all students who are not registerd at a specific school. So i use this script in a graph. This graph should show all students who are currently taking class at a specific school. The formule works. The only problem i have is that it only works when I select "Volgt opleiding" in the selectioon box which tells me wether a student is or isn't registerd at that school. I would like to have a working formula without having to make a selection in the selection box

if (StatusInschrijving='Volgt opleiding',COUNT(Distinct LeerlingID))

Gr. Sandeep

Re: Using an if-statement

Miguel_Angel_Baeyens — Mon, 05 Mar 2012 14:38:22 GMT

Hi,

Try the formula using set analysis

Count({< StatusInschrijving = {'Volgt opleiding'} >} DISTINCT LeerlingID)

Hope that helps.

Miguel

Using an if-statement

shahamel — Mon, 05 Mar 2012 14:47:40 GMT

Thanx