topic Re: count with condition in QlikView

count with condition

Anonymous — Mon, 03 Sep 2012 03:25:38 GMT

hay

i have 2 field one is the date and the second is the condition.

i wnat to know how much time the condition 1 apear.

i use this one but i get nothing 😞

=Count({$<[condtion]={"0"}>}[date])

i need to count the date field ,just if the second field show 0 , how can i do that ?

thanks'

yarin

nilesh_gangurde — Mon, 03 Sep 2012 05:47:38 GMT

Heyy ,

Check out the field "condition" is in which format.

if its in text then it will not show anything for the above expression.

Regards,

Nilesh Gangurde

thomas_skariah — Mon, 03 Sep 2012 05:48:35 GMT

Hi Yarin,

Just try the following code =count(if(condtion=0,date)).

Regards,

Tom

Mon, 03 Sep 2012 06:03:40 GMT

hi,

please try this expression

=count({<[condition]={"=null()"}>}[date])

I hope this will help.