Please help

Anonymous — Fri, 15 Mar 2013 18:50:58 GMT

Hello,

Could you help me to select only date, where Result<70%?

Please see attached file.

Thanks,

Re: Please help

udit_kumar_sana — Fri, 15 Mar 2013 19:45:36 GMT

Hi,

you can write this in your straight table expressions:

1.)For Result:-

if(((Count({<MYear={'$(=MonthName(max(MYear)))'}, Result={'Yes'}>}Result)/

Count({<MYear={'$(=MonthName(max(MYear)))'}>}TOTAL<submitDateTime>Result))*100)<=70,((Count({<MYear={'$(=MonthName(max(MYear)))'}, Result={'Yes'}>}Result)/

Count({<MYear={'$(=MonthName(max(MYear)))'}>}TOTAL<submitDateTime>Result)))*100)

2.)for Sample size:-

=if(isnull(column(1)),0,Count({<MYear={'$(=MonthName(max(MYear)))'}>}TOTAL<submitDateTime>Result))

Regards,

Udit

Re: Please help

Anonymous — Fri, 15 Mar 2013 19:58:48 GMT

Thank you so much

topic Please help in QlikView

Please help

Re: Please help

Re: Please help