topic How to count occurrences of something in SQL load? in QlikView

How to count occurrences of something in SQL load?

Wed, 08 Aug 2012 09:46:40 GMT

So I have:

SQL SELECT * FROM Users;

..and I know the Users has a column Active where each record contains a string that is either 'true' or 'false' .

How do I get the number of loaded occurrences of the string 'true' in that column, so that I can show the full count regardless of how the user makes selections etc. when that data is displayed on a Table Box?

A Text Object with something like =Count(if(Active='true', 1)) won't do because it changes based on selections.

Re: How to count occurrences of something in SQL load?

Anonymous — Wed, 08 Aug 2012 09:51:00 GMT

well.. you can always ignore the selections like this... =Count({1} if(Active='true', 1))

Re: How to count occurrences of something in SQL load?

MayilVahanan — Wed, 08 Aug 2012 09:54:20 GMT

you can use count({1}if(Active ='true',1))

or in script seet flag like or separate the active value is true

load * ,if(Active = `true`,Actvie) As actvietrue;

select * Frrom tablename;

hope it helps