How can I do this type of Count If expression in the script?

[jblomqvist]

Hello all,

I have the following sample data:

What I want to do is create a No of Months <>0 type of column in my table where ActualValue is not 0 for those months.

I tried doing If([Actual Value]>0, Count([Actual Value])) but it doesn't work.

Any ideas how I can create the above? I must mention my MonthYear is not in this table, it is in a calender table.

Any ideas?

[qlikviewwizard]

Hi Check this,