Count Script Returns No Results

[Anonymous]

Why the below code is not showing any result

count({$<$(=[Hours Entered]/[Available hours]) ={'<1'}>} and {<[Month]='April'>}Name)

[Anonymous]

Hi Sujeeth,

Welcome to the Qlik Community! We happy to have you here.

I have edited the title of this thread from "Hi" to "Count Script Returns No Results" to make it more descriptive. I've also moved it from the Qlik Community Information space to the New to QlikView space, as that is more appropriate for this content.

In the future, please use short but descriptive titles and look for the space that is most fitting for your question, as that will help you get the best responses to your questions.

Thank you!

Qlik Community Team

[isingh30]

What exactly is your requirement? Try like this

count({$<[Hours Entered]/[Available hours] ={'<1'}>} , {<Month={'April'}>}Name)

Thanks

[vishsaggi]

Try like

count({$< Name = {"=([Hours Entered]/[Available hours]) <1" >}, [Month] = {'April'} >}Name)