topic Re: How to change expression? in QlikView

How to change expression?

Fri, 14 Feb 2014 16:36:24 GMT

Hi,

I have expression as below in Straight table. This will gives the number of students we got in that working week

Count(DISTINCT {<Post={'Enter'}>}StudentID)

I need to change the expression to get without NULL values. can anyone help me how to change this?

Thanks.

Fri, 14 Feb 2014 16:40:13 GMT

Hey Amelia,

Nulls wont be counted. It will only count for Post = Enter

Thanks

MK_QSL — Fri, 14 Feb 2014 16:40:14 GMT

Count(DISTINCT {<Post={'Enter'}>}NOT ISNULL(StudentID))

Fri, 14 Feb 2014 16:45:53 GMT

Attached a sample file to show that your expression wont count null values.

Thanks

Fri, 14 Feb 2014 17:36:55 GMT

Thanks and If I want to create how many students entered each week means will the below work?

Dimension 1=IF(FiscalWeekSerial>=$(curFiscalWeekSeq)-4,FiscalWeek)

Dimension 2 = Organisation

Expression= Count(DISTINCT {<Post={'Enter'}>}StudentID)

MK_QSL — Fri, 14 Feb 2014 17:43:09 GMT

Dear Amelia,

If you post your sample file, it will be more helpful to work on.